XL has to have some way of guessing whether 03/06 means (a) the 3rd of
June (in the current year), (b) the 6th of March (again in the current
year), and (c) March of 2006.

By default, XL will try to resolve ambiguous dates such as you're
entering as mm/dd (or dd/mm, depending on your system settings) of the
current year. If that doesn't make sense (e.g., 1/45), then it will try
to resolve it as a mm/yy if it can.

See XL Help "About dates and date systems" for the rules XL uses to
interpret ambiguous dates and how to customize them.

In article ,
help with excel wrote:

when i open excel and type in other date/s (not Current date) why does it go
to current date and how can i stop this from happening. all i want to do is
input numbers for example: 03/06;04/05 but when i do this it goes to current
date.

thanks