| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting billion to million
What is the formula to convert:
1,784,543,000 to 1.784 639,954,000 to 640 Best regards, Alex |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting billion to million
With numbers in A1 and A2
B1 enter =A1/1000000000 format to 2 DP B2 enter =A2/1000000 format to 0 DP Gord On Fri, 3 May 2013 05:45:10 -0700 (PDT), Alex Hyat wrote: What is the formula to convert: 1,784,543,000 to 1.784 639,954,000 to 640 Best regards, Alex |
|
#3
|
|||
|
|||
|
Quote:
[=1000000000] #,##0.0,,, "Billion";[=1000000]#0,,; #, "k" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Number Formats - Billion Dollars Rounded | Excel Worksheet Functions | |||
| tell me the formula of converting amount to million from koror | Excel Discussion (Misc queries) | |||
| How do I automatically convert $1,234,555,678.05 to $1.5 billion? | Excel Worksheet Functions | |||
| Find-Replace Billion-1 | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
Linear Mode
