Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AAMC
 
Posts: n/a
Default Convert numbers into its equivalent in words?(12 to Twelve)

Is there any function that allows me to convert number into their equivelent
in words? Please advise
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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

--

HTH

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


"AAMC" wrote in message
...
Is there any function that allows me to convert number into their

equivelent
in words? Please advise



  #3   Report Post  
Andy Wiggins
 
Posts: n/a
Default

This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"AAMC" wrote in message
...
Is there any function that allows me to convert number into their

equivelent
in words? Please advise



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 text to numbers vipa2000 Excel Worksheet Functions 3 August 1st 05 09:01 PM
How do I convert numbers stored as text with spaces to numbers Baffuor Excel Discussion (Misc queries) 1 May 24th 05 07:39 AM
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
Convert text to numbers gennario Excel Discussion (Misc queries) 6 January 10th 05 11:56 PM
How to convert Numbers to text Calif_guy Excel Worksheet Functions 1 November 12th 04 05:12 AM


All times are GMT +1. The time now is 03:11 AM.

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"