Display of $ in Msgbox

D

David

In XL2000, I use this to display the check# & amount a check was written
for:
MsgBox "Check for $" & Range("I3").End(xlDown)(1, 5) & _
" was #" & Range("I3").End(xlDown)(1, 2)

An appearance problem is that I would like an amount like $12.00 to show as
that rather than $12, or $12.80 instead of $12.8 - OK? I can't use a text
value because these items are summed at the bottom of the sheet.

Any way to get what I want?
 
F

Frank Kabel

Hi
try:
MsgBox "Check for $" & format(Range("I3").End(xlDown)(1, 5),"0.00") & _
" was #" & Range("I3").End(xlDown)(1, 2)
 
D

David

Frank Kabel wrote
MsgBox "Check for $" & format(Range("I3").End(xlDown)(1, 5),"0.00") & _
" was #" & Range("I3").End(xlDown)(1, 2)
Click to expand...

Easy when you know how. Thanks.

I was thinking in that direction after posting and realizing how stupid I
was to say that something in a MsgBox couldn't be text. Never would have
come up with the proper syntax on my own, though.
 
Top