What is the formula to convert: 1,784,543,000 to 1.784 639,954,000 to 640 Best regards, Alex
A Alex Hyat May 3, 2013 #1 What is the formula to convert: 1,784,543,000 to 1.784 639,954,000 to 640 Best regards, Alex
G Gord Dibben May 3, 2013 #2 With numbers in A1 and A2 B1 enter =A1/1000000000 format to 2 DP B2 enter =A2/1000000 format to 0 DP Gord
With numbers in A1 and A2 B1 enter =A1/1000000000 format to 2 DP B2 enter =A2/1000000 format to 0 DP Gord
C Crunches May 3, 2013 #3 Alex said: What is the formula to convert: 1,784,543,000 to 1.784 639,954,000 to 640 Best regards, Alex Click to expand... You can format the cell to "custom" and put in: [>=1000000000] #,##0.0,,, "Billion";[>=1000000]#0,,; #, "k
Alex said: What is the formula to convert: 1,784,543,000 to 1.784 639,954,000 to 640 Best regards, Alex Click to expand... You can format the cell to "custom" and put in: [>=1000000000] #,##0.0,,, "Billion";[>=1000000]#0,,; #, "k
