ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Converting number to text (https://www.excelbanter.com/excel-programming/365656-converting-number-text.html)

T De Villiers[_26_]

Converting number to text
 

How do I go from:

1 to one
2 to two

etc.etc. all tyhe way up to 200, grateful for any hel

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=55648


Bob Phillips

Converting number to text
 
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"T De Villiers"
wrote in message
news:T.De.Villiers.2a49c2_1151505011.891@excelforu m-nospam.com...

How do I go from:

1 to one
2 to two

etc.etc. all tyhe way up to 200, grateful for any help


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile:

http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=556488




T De Villiers[_27_]

Converting number to text
 

Thanks Bob- very helpfu

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=55648


T De Villiers[_28_]

Converting number to text
 

Thanks Bob- very helpfu

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=55648



All times are GMT +1. The time now is 05:28 PM.

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