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

Have a look @ this old thread;


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

How about having this formula in C1


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

hope it helps


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

Sulman, you can also check out