Converting 0 to a Dash without using Currency

  • Thread starter Thread starter cardan
  • Start date Start date
C

cardan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top