Quote:
Originally Posted by Guessed
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)
|
Interesting. OK, I'll stop for tonight, or else I will be too tired tomorrow.
Thank you thank you thank for the lesson.
Interesting topic
If I do find the answer one day, I'll let you know
Night my forum smart friend