software

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)

Hi

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

groups.google.co.uk/groups?q=... text"amp;hl=en

Andy.

quot;paddingtonquot; gt; wrote in message
...
gt; Is it possible to format a cell in Excel so that if a number is entered,
gt; (say
gt; 100) it comes up as text, (one hundred)
See www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;paddingtonquot; gt; wrote in message
...
gt; Is it possible to format a cell in Excel so that if a number is entered,
(say
gt; 100) it comes up as text, (one hundred)