Number format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jamal - 23 Jan 2008 01:17 GMT

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.

Reply to this Message

ryguy7272 - 23 Jan 2008 21:09 GMT

Right-click > Format Cells > Custom > Type
Does that do it for ya?

Ryan--

Signature

RyGuy

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

Reply to this Message