Number format

  • Thread starter Thread starter Jamal
  • Start date Start date
J

Jamal

How do I set the default number format to be #,##0;[Red](#,##0), which will
avoid the dash sign for nrgative numbers and add a thousand seperator. I am
still using Excel 2000. Thanks for your help.
 
Right-click > Format Cells > Custom > Type
Does that do it for ya?

Ryan--
 
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

Displaying zeros in cells 2
Number with dash is importing as date 9
How to remove dashes in Social Security number 15
Text Formats 4
Thousand/Decimal seperator 3
Format alphanumeric field in Excel 10
Default number format in Excel 1
Removing Dashes in Excel 4

Back
Top