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
|