View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Comma in number in msgbox

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.