[Lianna]

I have a message box that shows a message and a value from
a worksheet. How do I define the number format of the
value in the message box?

I'm using Excel 2000.

Thanks,
Lianna

[Tom Ogilvy]

If you want to display what is displayed in the cell rather than the
underlying value

msgbox Range("a1").Text

rather than
msgbox Range("A1").Value

Regards,
Tom Ogilvy


"Lianna" wrote in message
...
I have a message box that shows a message and a value from
a worksheet. How do I define the number format of the
value in the message box?

I'm using Excel 2000.

Thanks,
Lianna