How do I convert a number in Excel to text?
 

For example I have the number 5 in a cell and need to change it to the word
five.

How do I convert a number in Excel to text?
 

Answer courtesy of xlDynamic.com which points to some Microsoft knowledge
base entries.

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

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...;EN-US;Q213360

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...;EN-US;Q140704

If you want a complete solution, then Laurent Longre has an addin that
provides language support and much more. You can get it
http://xcell05.free.fr/


Regards

Trevor


"Hoff" wrote in message
...
For example I have the number 5 in a cell and need to change it to the
word
five.

How do I convert a number in Excel to text?
 

See:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;q140704&;


--
Gary's Student


"Hoff" wrote:

For example I have the number 5 in a cell and need to change it to the word
five.