script for date and currency formating

B

BRustigian

Hello all, could you help me with the script for date and currenc
formating? I have a workbook where I am sourcing data and includin
data in a sentence. It looks like this, ="Payment due"&" "&H15&
"&I15&"". Cell H15 is a date and I15 is a dollar amount. Both thes
numbers display as numbers with no formating i.e. August 3, 2006 an
$2,432.12. Is there a script that will format this? Thank
 
T

Toppers

try:

="Payment due " &TEXT(H15,"mmmm, d yyyy") & " " & TEXT(I15,"$#,##0.00")

HTH
 
Top