can i convert numbers to text automatically
 

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)

can i convert numbers to text automatically
 

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=...+text%22&hl=en

Andy.

"paddington" wrote in message
...
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)

can i convert numbers to text automatically
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"paddington" wrote in message
...
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)