Thread: How do I convert numbers to text like bahttext but in sterling
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How do I convert numbers to text like bahttext but in sterling
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ramsess" wrote in message
...
I wish to convert the number value in one cell to text in another

e.g.
£123.56 One hundred and twentythree pounds fiftysix pence


Reply With QuoteReply With Quote