Date defaults to 2007

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.
 
N

Nick Hodge

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
Click to expand...
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy from one worksheet to another changes the year from 2009 to 2 3
Opening a File in Excel 2007 1
Excel DateDif - why does 2007 seem different? 3
date corruption? 00/01/1900 1
Transferring files from a MAC 1
VBA - retrieve data on last create named range from previous inserted named range 0
Remove date format? 3
typed dates not recognized 3

Top