It appears that Word and Excel start using the "10 to the power of" formatting if the numbers have 8 digits or more. When the numbers are smaller than that you don't need to worry about it too much.
You can make the code more complex to let Word choose its own format when the numbers are less than 10,000,000 by using an If/Else in your code.
I don't know why the StatusBar display method treats the result differently.
Maybe you would find this works better for your scale of numbers
MsgBox CDbl(Selection.Calculate)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|