Display of $ in Msgbox
 

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?

--
David

Display of $ in Msgbox
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


David wrote:
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?

Display of $ in Msgbox
 

Frank Kabel wrote

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

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.

--
David