When typing dates do not default to current year.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used to (with my old computer) be able to type in "Jul 5" as an example,
and have Excel populate the cell with the current year "Jul 1, 07" ie. fill
the year. With my new computer, it fills this input as "Jul 1, 01" Any
ideas on how I can get the current year to populate automatically?
 
When you say Jul 1, Excel assumed that you meant Jul 2001 (and if you put in
a month and a year, Excel defaults to the first of the month).
I think you'll find that if you type in 1 Jul, rather than Jul 1, it will
take it as 1st July in the current year.

If there is a difference between your new and old computers, I might wonder
whether there is a difference in Windows regional settings, but I haven't
experimented to see what settings (if any) might have given the behaviour
you saw previously.
 
Thanks for the help. Your solution does work. What I find odd, is with my
old computer, and with others in our office, you can autofill the current
year when you type "Jun 30" or any other month and date. The year did on my
old computer, and others in our office would complete this as 30-Jun-07 or
what ever format you had your dates set up.
 
Back
Top