| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make 1,000,000 into 1 million
I have number in millions like 2,098,009 and I want them to change to 2 (in
millions) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make 1,000,000 into 1 million
Try a Custom Number Format:
Select the cell(s) to be impacted From the Excel main menu: <format<cells<number tab Category: Custom Type: #,##0,," Million"_);(#,##0,," Million") 2,000,000 displays as 2 Million -2,000,000 displays as (2 Milliion) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Becky" wrote: I have number in millions like 2,098,009 and I want them to change to 2 (in millions) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parts Per Million Formula | Excel Discussion (Misc queries) | |||
| 1 Million Rows ?? | New Users to Excel | |||
| 10 million appears as 10,000,000.00 | Excel Discussion (Misc queries) | |||
| Make 1 Million Dollars $$ | New Users to Excel | |||
| How can I get 7.3 million data pts on one line graph? | Excel Discussion (Misc queries) | |||
Linear Mode
