Converting 0 to a Dash without using Currency
 

Hello All,
I am trying to convert a zero (0) to a dash. I know I can do this as a
currency format but when I do that it does not center. I am trying to
do a custom format that would allow me to convert the number 0 to a
dash (-) and allow me to move it to the center or left hand side of
the cell. Any suggestions would be greatly appreciated! Thank you!

Converting 0 to a Dash without using Currency
 

_($ #,##0_);_($ (#,##0);_($ "-"_);_(@_)

this allows you to align as you describe.

--
Regards,
Tom Ogilvy



"cardan" wrote:

Hello All,
I am trying to convert a zero (0) to a dash. I know I can do this as a
currency format but when I do that it does not center. I am trying to
do a custom format that would allow me to convert the number 0 to a
dash (-) and allow me to move it to the center or left hand side of
the cell. Any suggestions would be greatly appreciated! Thank you!