VBA NumberFormat question

[alexaronson]

Hello and thank you for helping me on my question.

I have this line of code to format some values.

ActiveSheet.Columns("F:I").NumberFormat = "$#,###,###.00"

The output of this code is producing a result like this: -$8.00

I would like to get a result that looked like this: $ -8.00 or $ (8.00)

Any suggestions on how I can do this?

Thank you for your help!
-Alex Aronson

 

[Norie]

For $-8.00:

$#,###,###.00;$-#,###,###.00

For $(8.00):

$#,###,###.00;$(#,###,###.00)