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

[DW]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[David Biddulph]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

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

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

Vaya con Dios,
Chuck, CABGx3