Coen

Pre-format the cells as text or precede with a leading '. (That will not
show)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Coen" wrote in message
...
When I enter "3-1" in a cell, Excel changes this automatically to "3-jan".
If
I then manually change the format of the cell to text, the content of the
cell changes to "37989", not the original "3-1".

How do I switch off this automatic formatting?

Thanks for any suggestions...