Nick

find "option to prevent Excel changing 1-2-3 to a date" and agree with the
suggestion.

--
Vince


"Nick Turner" wrote:

Hi

Is it possible to turn off the automatic formating of certain cell entries
to dates.

For example if I type in 6-10 (meaning six to ten), Excel presumes a date
was entered and 6/10/2005 is entered and displayed as 6-Oct.

An other example is 04/05 (meaning the financial year 2004/05), excel
presumes a date and enters 4/05/2005 and displays 4-May.

I know its possible to enter these values other ways (eg
=concatenate("6-10")), but is there a way to "turn off" this automatic coding
into a date.

Thanks, any help would be appreciated.