ExcelBanter - Number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Number format (https://www.excelbanter.com/excel-programming/404780-number-format.html)

Jamal

Number format

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.

ryguy7272

Number format

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

Ryan--

--
RyGuy

"Jamal" wrote:

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.

All times are GMT +1. The time now is 09:21 AM.