formatting in thousands

  • Thread starter Thread starter patti
  • Start date Start date
P

patti

I figure there must be an easy way to do this. I would like 1,000 to
display as 1, or 17,000 to display as 17.
My boss says just divide by 1,000!!
 
Tools>Options>Edit, set the Fixed Decimal Places checkbox, and set the
places to 3.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
select dat aand do Format / Cells - Pick any numeric format, then hit custom
and put a comma at
the end of each segment, eg if you just used number format then you would
have

0.00 so add comma to get
0.00,

or from 0 to 0,

Accounting format as another example

_-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_- to
_-£* #,##0.00,_-;-£* #,##0.00,_-;_-£* "-"??_-;_-@_-

Each comma will reduce by factor of 1000, so 2 commas give you millions etc

eg 0,,
 
It displays 1000 as 1 for me, 17000 as a 17

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top