Thread: Change numeric value to it's text equivalent, ie dollar values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Change numeric value to it's text equivalent, ie dollar values
Check out the links on this site:

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Hope this helps.

Pete

On Nov 7, 5:26*pm, jubu wrote:
I am looking for a function that would convert a dollar value to the
equivalent text phrase. *Example: *$1,923.45 would become One Thousand Nine
Hundred Twenty-Three and forty-five hundredths dollars or a phrase similar to
what is usually printed on a check.
--
jubu

Reply With QuoteReply With Quote