converts a number to text eg. "2" become "two"

N

Norman Jones

Hi CQ,

You could download Laurent Longre's MoreFunc addin which is freely
downloadable at:

http://xcell05.free.fr/

The addin includes the NBTEXT function which converts a positive number into
spelled-out text (supports 13 languages).

Also see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
'How to convert a numeric value into English words in Excel'

and
http://support.microsoft.com/?scid=kb;en-us;259663
'How To Convert Currency or Numbers into English Words'

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to converts a number to text eg. "2" become "two" 3
How to convert a numericaldigit to words?Thanks inadvance. 5
How do I convert $500 to Five Hundred Dollars? 1
how to convert a figure in words? 1
Values in words 2
Display Numbers as Words 3
Number value to text as percentile 2
Import to a New Table 1

Top