Custom Number Formats

[Mary Ann]

How do I create a custom number format to return thousands e.g. if the value
is 1000 the format shows 1

 

[Andrea Jones]

Under Format -> Cells in the Custom format box type

#,

(make sure you put the comma in). This will only show the thousands part,
note that it will round numbers like 2598 up to 3 instead of 2.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

 

[Damon Longworth]

Try this custom number format:

0,

Or:

#,

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com

 

[Debra Dalgleish]

Select the cells
Choose Format>Cells
On the Number tab, select the Custom category
In the text box, type: #,
Click OK

 

[Gary Brown]

Try the following custom format:-

#,###,

This will display 1,523,754.25 as 1,524

Add how you want negative numbers to display at the end by sepearting
the codes with a semi colon (ie in brackets minus sign etc)

 

[Mary Ann]

Thank you

Under Format -> Cells in the Custom format box type

#,

(make sure you put the comma in). This will only show the thousands part,
note that it will round numbers like 2598 up to 3 instead of 2.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

 

[Mary Ann]

Thank you

Select the cells
Choose Format>Cells
On the Number tab, select the Custom category
In the text box, type: #,
Click OK

 

[Mary Ann]

Thank you

Try this custom number format:

0,

Or:

#,

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com

 

[Mary Ann]

Thank you