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