View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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)