ExcelBanter - Converting billion to million

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting billion to million (https://www.excelbanter.com/excel-discussion-misc-queries/448700-converting-billion-million.html)

Alex Hyat

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

Gord Dibben[_2_]

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

Crunches

Quote:

Originally Posted by Alex Hyat (Post 1611575)

What is the formula to convert:

1,784,543,000 to 1.784
639,954,000 to 640

Best regards,

Alex

You can format the cell to "custom" and put in:

[=1000000000] #,##0.0,,, "Billion";[=1000000]#0,,; #, "k"

All times are GMT +1. The time now is 02:43 PM.