Date defaults to 2007

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

Guest

I'm running office 10.1.5 on a power mac G4 OS 10.2.3. After the new year I found that when I create a new worksheet in Excel and add a date it defaults to 2007. Also, if I copy and paste a row from another worksheet that has the year set at 2003, when pasted into the new worksheet it changes the year to 2007. Any suggestions anyone might have would be greatly appreciated.
 
Tools>Options>Calculation and un-check 2004 date system. (I believed this
was put in for compatibility with Macs so it might need checking). Either
way it's your issue

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Delsol13 said:
I'm running office 10.1.5 on a power mac G4 OS 10.2.3. After the new year
I found that when I create a new worksheet in Excel and add a date it
defaults to 2007. Also, if I copy and paste a row from another worksheet
that has the year set at 2003, when pasted into the new worksheet it changes
the year to 2007. Any suggestions anyone might have would be greatly
appreciated.
 
Back
Top