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
