How do I make into a dollar format when in a formula?

K

krissy

"We have been asked to contact you by our client 0, regarding your
past due invoice for 7896.98. Their records indicate that payment has
not been received as of the date of this correspondence, and is therefore
listed for collection. This balance may include finance charges. "


How do I make the 7897.98 w/ a dollar amount? The current formula is " & c8
& ".

Please HELP!!!
 
G

Gary Keramidas

do you mean a dollar sign? unless i'm missing something, depending on where
you get the rest of the sentence:

"We have been asked to contact you by our client 0, regarding your
past due invoice for $" & c8 & "."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in a sentence 5
Formulas in a sentence.... 2
How do I show a percentage in Excel? Or do a simple subtraction? 1
How Do I Add Dates in a formula? 3
My Lottery Win! 4
How do I create a formula in excel to multiply two items from two 2
How do I allow users to make a choice in a worksheet? 2
how do I make a 10 minute presentation out of 5 pages? 8

Top