Thread: Character and number in a cell - Can you help?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
  
Posts: 1
Default Character and number in a cell - Can you help?

You can only format a cell as number or text, so you must format as Tex
in this case. If you need to use the numbers in a calculation you wil
have to convert the text back to numbers in your formula or use anothe
column for the numbers perhaps hidden).


--
Brian

-----------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...tinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27829

Reply With QuoteReply With Quote