View Single Post
 
Old 09-12-2022, 07:45 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote