Format dollars in formula

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I have a formula like this ="TO COLLECT $"&SUM(G4:G999)-SUM(H4:H999)

The results is this "TO COLLECT $60713.44"
I want the dollar amount to look like this $60,713.44
Any Idea?
 
Jacob,

You can have the cell formatting take care of both the number formatting (the $, the commas
and decimal point, etc.) and the "TO COLLECT" part.

Put your formula in the cell:
=SUM(G4:G999)-SUM(H4:H9999)

And format it, Format - Cells - Number - Custom tab. In the "Type" box, put:
"TO COLLECT" $#,##0.00
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top