Formatting number cells

  • Thread starter Thread starter geoff
  • Start date Start date
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.?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

zeros show as dashes in spreadsheet, want to show 0. 2
Displaying zeros in cells 2
Formatting number 7
Custom Number Format for text 8
custom number format 1
formatted to place dashes within numbers formatted as text 1
Formatting zeros as dashes 4
Red cell for negative numbers in Excel 1

Back
Top