View Single Post
 
Old 09-12-2022, 08:00 PM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
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
Reply With Quote