Custom Number Formats
 

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

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" wrote:

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

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" wrote in message
...
How do I create a custom number format to return thousands e.g. if the
value
is 1000 the format shows 1

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

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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)


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=385200

Thank you

"Andrea Jones" wrote:

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" wrote:

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

Thank you

"Debra Dalgleish" wrote:

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

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you

"Damon Longworth" wrote:

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" wrote in message
...
How do I create a custom number format to return thousands e.g. if the
value
is 1000 the format shows 1

Thank you

"Gary Brown" wrote:


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)


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=385200