View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Formulas in a sentence....

You'll probably want to format the amount due:
="We have been asked to contact you by our client "&C6 " regarding your
past due invoice for "&TEXT(C8,"#,##0.00")

Regards,
Fred

"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
try this

="We have been asked to contact you by our client " & C6 & ", regarding
your past due invoice for " & C8



--


Gary Keramidas
Excel 2003


"krissy" wrote in message
...
We have been asked to contact you by our client =c6 , regarding your past
due
invoice for =c8.

What would the formula be?