is not number (dash) number is not a number only a text.
in that case type '(single apostrophe)10-5


Wozniak wrote in message
...
I have a problem that when I open a file, like text or csv file, the cell
with number dash number, ex. 10-5, will be automatically changed to date
format. But this really affect my data analysis. I know we could add '
before
typing or change cell format before typing, but how to cancel this
autoformat
when opening another file??

Thanks