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

D

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

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
D

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

CLR

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

Vaya con Dios,
Chuck, CABGx3



David Biddulph said:
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 said:
Right-click > FormatCells > NumberTab > NumberSelection > 0 DecimalPlaces
check the "Use thousands separator" box

Vaya con Dios,
Chuck, CABGx3
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

round numbers in the millions to numbers in the thousands 2
Rounding value from millions to decimal places 6
how to convert number to words 4
truncate numbers from millions to thousands 3
Round To The Nearest Thousand or Million 3
Can I rounddown a cell result from millions to thousands 3
Changing Millions to Thousands 3
Notepad or .txt file to excel 2

Top