Cell format - how to disable auto date

K

KH_GS

I want the cell to be "3 - 5" but it auto changes it to "5-Mar".

How do I stop that from happening besides using '3-5 ?
 
P

Peo Sjoblom

Only way is to either precede each entry with an apostrophe ' (it's not
visible in the cell) or to pre-format as text

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top