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