Thread: Converting billion to million
View Single Post
  #3   Report Post  
Crunches Crunches is offline
Junior Member
  
Posts: 1
Default
Quote:
Originally Posted by Alex Hyat View Post
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"
Reply With QuoteReply With Quote