Thank you. I tried the first one and that worked. Thanks again! Connie

"Dave Peterson" wrote:

Another guess...
0.0;-0.0;-;General
or
#,##0.0;-#,##0.0;-;General


Connie Martin wrote:

We meet again! Hi! Yes, that works, except have I have 8 decimal numbers
now. I only want one decimal. Is there a way to combine all that? Connie

"T. Valko" wrote:

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




--

Dave Peterson