How do I change a file displayed in thousands to millions?
 

I have a large data set that is currently displayed in thousands (ex.
2115.005), how do I change to display in millions (ex. 2,115,005)?

How do I change a file displayed in thousands to millions?
 

Right-click FormatCells NumberTab NumberSelection 0 DecimalPlaces
check the "Use thousands separator" box

Vaya con Dios,
Chuck, CABGx3



"DW" wrote:

I have a large data set that is currently displayed in thousands (ex.
2115.005), how do I change to display in millions (ex. 2,115,005)?

How do I change a file displayed in thousands to millions?
 

You'd need to multiply by 1000 as well, wouldn't you, Chuck?
[Though the OP has been inconsistent in referring to numbers "displayed in
thousands" and "displayed in millions" as in his example he seems to have
gone from thousands to units.]
--
David Biddulph

"CLR" wrote in message
...
Right-click FormatCells NumberTab NumberSelection 0 DecimalPlaces

check the "Use thousands separator" box

Vaya con Dios,
Chuck, CABGx3



"DW" wrote:

I have a large data set that is currently displayed in thousands (ex.
2115.005), how do I change to display in millions (ex. 2,115,005)?

How do I change a file displayed in thousands to millions?
 

'Reckon so David.......good catch.

Vaya con Dios,
Chuck, CABGx3



"David Biddulph" wrote:

You'd need to multiply by 1000 as well, wouldn't you, Chuck?
[Though the OP has been inconsistent in referring to numbers "displayed in
thousands" and "displayed in millions" as in his example he seems to have
gone from thousands to units.]
--
David Biddulph

"CLR" wrote in message
...
Right-click FormatCells NumberTab NumberSelection 0 DecimalPlaces

check the "Use thousands separator" box

Vaya con Dios,
Chuck, CABGx3



"DW" wrote:

I have a large data set that is currently displayed in thousands (ex.
2115.005), how do I change to display in millions (ex. 2,115,005)?