MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting Numeric Value in Text in Excel 97?


Posted by sulmau on May 08, 2001 4:01 AM

Hi All!

I want to convert numeric value entered in a cell to text value to another cell i.e. if I type 100 in cell A1 then the output of A1 should be in other cell say c1 in text format i.e. One Hundred.
How can I do this?
Hope my question is understandable.

Awaiting helpful reply.

Thanks & Regards / Sulman


Posted by Ivan Moala on May 08, 2001 5:25 AM

Sulman
Have a look @ this old thread;
http://www.mrexcel.com/archive/messages/1559.html

Ivan

Posted by Richie Turner on May 08, 2001 5:44 AM

How about having this formula in C1

=TEXT(A1,"0")

NB. the "0" is the format for the number ie. no decimals

hope it helps

Richie

Posted by Barrie Davidson on May 08, 2001 1:38 PM

Sulman, you can also check out
http://www.barasch.com/excel/numb2words.htm

Barrie