View Single Post
  #7   Report Post  
Mary Ann
 
Posts: n/a
Default

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