MsgBox Application.Dollar(12345)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H." wrote in message
...
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.