can i convert numbers to text automatically

paddington · Mar 6, 2006

Is it possible to format a cell in Excel so that if a number is entered, (say
100) it comes up as text, (one hundred)

Guest · Mar 6, 2006

Hi

Have you done a serach on Google Groups for this? There are hundreds of
posts with replies!

http://groups.google.co.uk/groups?q="numbers+to+text"&hl=en

Andy.

Bob Phillips · Mar 6, 2006

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)