"James" wrote in message
...
I am trying to enter the value 1-5 in a cell it and keeps auto changing
into
the date! how do i stop this?

Format the cell as text before you enter the value. The alternative is to
precede the value with an apostrophe.
--
David Biddulph