|
|
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
|