Apple Mac, Trouble Shooting - Written by Darren Cornwell on Monday, September 22, 2008 11:47 - 1 Comment
Excel 2008, Copy / Pasting date field, wrong data….
Here’s another great head scratcher in the office debacle - why when you are copying date fields from one sheet to another does Excel feel the need to change the date? It all about the 1904 date format you see. All new sheets created in Excel are automatically set to the 1904 date format whereas all previous versions of Excel were set to the 1900 Date format - it’s an easy fix.
In the sheet that you wish to copy the date to, open up the preferences (Excel -> Preferences).
You then need to open up the ‘Calculations’ section of the preferences.
Then simple select and uncheck the ‘Use 1904 Date System’ - hey presto, if you copy data from your ‘old’ sheet, it will magically appear correctly in the new sheet!
Note: If you are using a Windows computer, you will need to go to Tools -> Options -> Calculation Tab.
1 Comment
Leave a Reply
Most Popular Content
- Vegas Day 3 / 4 and 5 - Where did all the hours go….
- Vegas - Day 2…. A winner I am!
- Vegas - Day 1 - Here we go again….
- Transferring Email - Apple Tiger to Leopard….
- Excel 2008, Copy / Pasting date field, wrong data….
- Web 1.0, 2.0 and 3.0
- Transferring a Wordpress Installation across Domains
- Microsoft Office 2008 Launches Setup Assistant Instead of the Application (Upgrade)….
- Vegas Day 11 or 12 or 13??
- Vegas Day 10
- Vegas Day…. Yeah, right, what day is it again?
- Have you made sure that all the files / folders have been restored to the exact...
- I tried this and while all the folders show up there appears no mail. Even thoug...
- Wow. Forgot I had posted here, I can't remember what I did to fix this, I think...
- I've been struggling with this stupid issue for the past few weeks. Now I find...
- Just keeping an eye on "what is he doing in Vegas" for god's sake win a few mill...
- WELL DONE MATE!...
- Thanks but I have tried several Product Keys I still have this wretched setup As...
- I heard about not bad application-...
More In Gaming
- Portal Ending Video
- Halo 3 Matchmaking Experience and Skill Explained
- 360 Red Ring of Death (Part 2)
- 360 Red Ring of Death
- XBLA - How hard can it be?


I’ve been struggling with this stupid issue for the past few weeks. Now I find out that it’s a “feature” and not a bug? Who gives a shit about macs that are so old, they can’t recognize dates prior to 1904? What percentage of Excel users will ever enter a date prior to 1904? Why are 99% of Excel 2008 users being subjected to this default functionality, when it is a detriment to our work? Leave it to Microsoft to create software that makes the Mac *less* useful.