Thread: function help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default function help

Hi

You can input a number preceded by a ' to make Excel treat it as text or
you can format the cell as text before you enter a number.

Hope this helps.
Andy.

"retrospect" wrote
in message ...

How can get a number to be shown as a text???


--
retrospect
------------------------------------------------------------------------
retrospect's Profile:
http://www.excelforum.com/member.php...o&userid=34173
View this thread: http://www.excelforum.com/showthread...hreadid=548911