I use Excel all day at work and got Office '13 at home.
Now I'm trying to enter data in a spreadsheet I brought home from work, originally created in Excel 2007 and where the first column is the date. I saved it to ensure it adopts the current settings.
I have many entries for 2013 to enter
In the list of formats this comes up twice like this:
Regardless of which on I select:
- If I type 2/24 I get 24-Feb-14
- If I type 2/24/13 I get 2/24/13
- If I type 13/2/24 I get 24-Feb-13
- If I type 2/24/15 I get 2/24/15
- If I type 15/2/24 I get 24-Feb-15
So this means Excel is recognizing dates entered in the 2/25/13 syntax only for the current year.
I have Windows8 on this new laptop and if it weren't for "Start8" I'd have returned the laptop and got one with W7 on it. I'd wasted more time in a week trying to use W8 than I'd wasted in the past 15 years on earlier versions. Now I'm finding stuff like this in Office '13. It seems they have made every aspect of everything ...unnecessarily complicated, graphic'd up with silly new icons and turned 'one step' operations into a 'hoedown'.
Anyone have any idea how to get it to accept dates in the 2/25/13 format?