Format as Text before you enter the data

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Amanda" wrote in message
...
I want the cell to have 5-6 but it keeps changing it to 6-May. I have tried
formatting the cell but to no avail. Is there a way to stop the
autoformatting?