WS.Range("A2").Value = FormatCurrency(vGrpAmt) & " is the amount for your
group."

Changing WS.Range("A2").Value to whatever is your cell.

Bill Horton

"JT" wrote:

I have a macro that outputs the following line on an Excel spreadsheet:

2260.54 is the amount for your group.

The code is as follows:

activecell.offset (0,5) = vGrpAmt & " is the amount for your group"

I would like for it to display as follows:

$ 2,260.54 is the amount for your group.

I'm having trouble getting the dollar sign and commas to display in the
output. Any suggestions would be appreciated. Thanks for the help.........
--
JT