unwanted cell formatting

[cerfitz]

every time I type a number containing a hyphen (03-8000) into a cell it is
automatically converted to date format even though the wporksheet is
formatted as general or number

 

[Max]

Either pre-format the data input range as TEXT,
or precede your input with an apostrophe (')
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik