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!

_($ #,##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!
>
>