Currency Format

[MikeG]

Someone helped me out by given me a custom format such that zeros will show as blanks. However, it also shows negatives as blanks, which I do not want. Can anyone tell me the form to make just zeros blanks?

Thanks,

Mike G


$#,##0.00;;""

 

[Joe4]

Maybe you want:

$#,##0.00;-$#,##0.00;""
(the logic is: positive number format;negative number format;zero format)

 

[MikeG]

Maybe you want:

$#,##0.00;-$#,##0.00;""
(the logic is: positive number format;negative number format;zero format)

Thanks Joe.

Perfect

Mike