Selection.NumberFormat = "$#,##0.00;"$0.00"&q

[sampson32]

I’m trying to display any negative currency as $0.00 thru code.

I can successfully show any negative values (currency) as $0.00 by right

clicking the cells and formatting using this custom format: $#,##0.00;”$0.00”

But I can’t successfully put this into code:

Selection.NumberFormat = "$#,##0.00;"$0.00""

It errors stating the $ sign is an invalid character

I’ve tried double quotes.

Does anyone know how to properly code this format?

Any help appreciated.

Thank you,

Vinnie

 

[Von Pookie]

Turn on the macro recorder, then right-click and format the cell. Then just stop the recorder, open the VBE to see the resulting code.

Doing that, looks to me like you're simply missing some quotes (").
You have to have the $0.00 in double-double quotes ( ""$0.00"" ), then the entire string itself needs to be within one set of quotes. The result being

"$#,##0.00;""$0.00"""

 

[sampson32]

Thanks!