You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
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