When typing dates do not default to current year.
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.
--
David Biddulph
"Spreadsheet Geek" wrote in
message ...
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?
|