View Single Post
 
Old 09-12-2022, 05:21 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
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

3E+07 means 3 followed by 7 zeros and is spoken as "three times ten to the power of seven".

If your totals are always whole numbers you can specify the formatting of the answer like this
Code:
MsgBox Format(Selection.Calculate,"#,##0")
or show two decimal places like this
Code:
MsgBox Format(Selection.Calculate,"#,##0.00")
Hint: You can experiment with number formatting in Excel to work out number formatting strings to use in this VBA.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote