View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default Formatting number

How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just like
the accounting format, but in Excel 2000 it doesn't let you center the number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the answer is
nothing. I want a dash, but want it centered. Thank you. Connie