ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CONVERT NUMBER TO ENGLISH TEXT (https://www.excelbanter.com/excel-discussion-misc-queries/244567-convert-number-english-text.html)

mgwad

CONVERT NUMBER TO ENGLISH TEXT
 
How can I convert from number to text? for example I need 10 converted to
(ten), 2 converted to (two).

Mike H

CONVERT NUMBER TO ENGLISH TEXT
 
Hi,

If you Google you'll find lots of ways but the Addin Morefunc is an
excellent tool and it's free and will do what you want

http://xcell05.free.fr/morefunc/english/

Mike

"mgwad" wrote:

How can I convert from number to text? for example I need 10 converted to
(ten), 2 converted to (two).


David Biddulph[_2_]

CONVERT NUMBER TO ENGLISH TEXT
 
Numbers to words:
a.. http://support.microsoft.com/kb/213360
b.. http://www.xldynamic.com/source/xld.xlFAQ0004.html
c.. http://www.ozgrid.com/VBA/ValueToWords.htm

--
David Biddulph

"mgwad" wrote in message
...
How can I convert from number to text? for example I need 10 converted to
(ten), 2 converted to (two).





All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com