Hi,
Try something like:

dim strValue as string

strvalue=Format( val(activecell.value), "$#,###.00")
strValue= "The value " & strValue & " is in the activecell, for example or
in a variable, Amt."

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Mike H." wrote:

How would I format the the display of a msgbox to get this result:

You have $2,145.50 worth of inventory!

The value 2145.5 is in the activecell, for example or in a variable, Amt.