Convert / translate numbers into text

[Guest]

IS there any way that I can Convert / translate a numbers into text in Excel 2003?

E.g. If I type in “1000†in Cell A1, Cell B1 will automatically display A1 value in word / text “One thousandâ€

 

[Norman Harker]

Hi Yean50!

You need a User Defined Function.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from here:

http://longre.free.fr/english/index.html

Numbers to Words Function along with many other useful Functions.

Unless you are Thai in which case you can use BAHTTEXT.

 

[JE McGimpsey]

See

How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=kb;en-us;140704

or


XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360