Trouble Shooting
Apple Mac, Trouble Shooting - 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.
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?
- 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-...
- @Diego - What version of Tiger are you using? As far as I know this fix works on...
- Thank you, but one thing - after i restart my computer, i have the same problem...
- Great post mate. Think I'll read your blog instead of writing my own.
:)...

