Hello Pros,
This might be challenging, but I don't know if it's fixable.

I found a video on how to calculate from text or in a table.

It works wonderfully, not the formula function but more like from this link, to add a command called:

• Calculate

Calculate
How to Perform Simple Calculations in Microsoft Word

The thing about it, is the it doesn't last long to show the results in the status bar, but it's accurate.

I was so proud of myself to have found a way to include a msgbox, like that it stays.

If I use the command/icon methode such as in the link above, I get the results accurately and the numbers are fully formatted.

*******Problem.
When I use the MsgBox which I've also created myself a personalized Word Tab and created my own Icon to calculate with the MsgBox and add such as these numbers as an example which I've tried In and Out of a table:
5,000,000
10,000,000
15,000,000

Select these 3 numbers, I click on the my Word VBA Icon = I get 3E+07 in the MsgBox.

Question:
How to get a MsgBox + Fully Formatted either with or without symbols $% + Without an 3E+07 message?

Unless it's not doable?



Any insights in the problem I get, I would be soooooooooooooooo grateful.

If it's not doable, please let me know so I will stop searching.