| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format millions in thousands with comma | Excel Discussion (Misc queries) | |||
| Change 7 to 7000 (like in thousands) | Excel Discussion (Misc queries) | |||
| truncate numbers from millions to thousands | Excel Worksheet Functions | |||
| Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
| Can I rounddown a cell result from millions to thousands | Excel Worksheet Functions | |||
Linear Mode
