Formatting number cells

G

geoff

I want to show a zero as a dash and negative numbers as (#). I can do
one or the other but how can I do both?

Is there any reference which explains the format specification in the
custom list of options.?
 
R

Ron Rosenfeld

I want to show a zero as a dash and negative numbers as (#). I can do
one or the other but how can I do both?
Click to expand...

Format/Cells/Number Custom Type: #;"(#)";-

Is there any reference which explains the format specification in the
custom list of options.?
Click to expand...

type "Number Format Codes" into HELP


--ron
 
Top