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 & "."
 
D

David Biddulph

="We have been asked to contact you by our client 0, regarding your past
due invoice for " & =TEXT(C8,"$0.00") & ". 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."

to force the 2 decimal places as well as the dollar sign.
 
D

David Biddulph

That doesn't put the right format into a mailmerged document or a
concatenated formula, Russell.
You need the TEXT function in Excel, or in MS Word mailmerge you could use
Word's field formatting functions.
 

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
Formulas in a sentence - last one.... 2
How do I input these formulas into cells that I want written in? 4
How do I make a formula work for all the cells in a column? 4
How do I figure out amout due from transaction file 3
How do I show a percentage in Excel? Or do a simple subtraction? 1
Make the result of a formula red (cannot be done in cond. format.) 4

Top