Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eagles199
 
Posts: n/a
Default How can I convert a Number into words. Ex: "10" as "Ten"

Is there any function available to convert numbers to words.
For Example, if I type "1000", the function should display "One Thousand"
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default How can I convert a Number into words. Ex: "10" as "Ten"

Try this:
http://www.meadinkent.co.uk/xlnumberstext.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Eagles199" wrote in message
...
Is there any function available to convert numbers to words.
For Example, if I type "1000", the function should display "One Thousand"



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert dates to number of days milk0s Excel Worksheet Functions 2 September 28th 05 01:31 PM
how can I convert numeric number into text firas Excel Discussion (Misc queries) 1 September 21st 05 07:05 PM
I wish excel to convert number to words ie 23 to twenty three razacbq Excel Discussion (Misc queries) 1 September 5th 05 09:41 PM
How do i convert number to wording Mohammad Irfan Excel Discussion (Misc queries) 2 August 19th 05 12:10 PM
how can i convert a number in words? HOP Excel Discussion (Misc queries) 1 November 27th 04 11:53 AM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"