View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cardan cardan is offline
external usenet poster
 
Posts: 112
Default 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!