format of calculations in msgbox

G

Guest

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format currency in MsgBox 3
calculations in a form 1
Format to percent in msg box 1
Calculate age from date of birth 7
Nz and Formats 1
Using expressions in Msgbox 2
MsgBox when query doesn't open 2
Select cell after last row in selection? 5

Top