Thread: script for date and currency formating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BRustigian BRustigian is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote