script for date and currency formating
 

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


--
BRustigian
------------------------------------------------------------------------
BRustigian's Profile: http://www.excelforum.com/member.php...fo&userid=4345
View this thread: http://www.excelforum.com/showthread...hreadid=568452

script for date and currency formating
 

try:

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

HTH

"BRustigian" wrote:


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


--
BRustigian
------------------------------------------------------------------------
BRustigian's Profile: http://www.excelforum.com/member.php...fo&userid=4345
View this thread: http://www.excelforum.com/showthread...hreadid=568452