View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] etradeguru@hotmail.com is offline
external usenet poster
 
Posts: 19
Default hyphen (nit minus) in cell

On 19 Sep, 09:40, Appalachia
wrote:
Seems such a simple thing...

How can I start text in a cell with a hyphen without Excel thinking it is a
minus sign.

Thanks

--
Confusion will be my epitaph...


Place a ' in front of your text
For exampleL -

enter 0001, and you get 1
enter '0001 and you get 0001.

Hope that answers your question.

Mark