format of calculations in msgbox

S

s4

Hi,
I have a msgbox that pops up, displaying a variance betweek 2 numbers.
Essentially it's "Blah blah blah" & [text1] - [text2]
Unfortunately when the box is displayed, the discrepency says e.g.
-12.124589999589999e

The discrepency should be in currency, is there any way to make sure the
msgbox displays this sum as ##.##?

Thanks
 
R

Rick Brandt

s4 said:
Hi,
I have a msgbox that pops up, displaying a variance betweek 2 numbers.
Essentially it's "Blah blah blah" & [text1] - [text2]
Unfortunately when the box is displayed, the discrepency says e.g.
-12.124589999589999e

The discrepency should be in currency, is there any way to make sure the
msgbox displays this sum as ##.##?

Thanks
Click to expand...

"Blah blah blah " & Format([text1] - [text2],"Currency")
 
Top