Formatting number cells
 

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.?

On 29 Jun 2005 08:00:48 -0700, "geoff" wrote:

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?


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


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

type "Number Format Codes" into HELP


--ron

Many thanks,
Geoff