copying to new sheet changes dates in column??
My bro has a spreadsheet, with 3 columns containing dates of upcoming events.
A B C D
abc 24 October 2011 16 January 2011 07 May 2012
xyz 24 October 2011 16 January 2011 07 May 2012
When he copies the sheet and pastes into a new sheet the dates change to
A B C D
abc 23 October 2007 15 January 2008 06 May 2008
xyz 23 October 2007 15 January 2008 06 May 2008
How mad is that!
I've even copied sheet using the sheet tab below, into new book, same thing.
Copied and Paste Value, same thing.
The Cels'l formating is " Date"
Please can someone explain this and how to resolve it.
Keys to the Problem copying to new sheet changes dates in column??
In all likelyhood, one workbok uses the 1904 date system and the other uses the 1900 date system.
Excel dates are really just the number of days since some base date.
Normally, dates are measured from 1900.
However, for compatibility with Mac Excel, there
is a setting you can use to specifiy the 1904 date system.
Open the Excel Options screen and choose the Advanced page.
There, scroll down until you get to the "When calculating this workbook" section.
There, uncheck the "Use 1904 date system".
Do this for
Using Windows troubleshooter:
- Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
- A new window will open. Click View all from the left pane.
- Scroll down to the bottom and click on Windows update.
- Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
- The troubleshooter will automatically detect problems and fix it.
- Now, close this window and try download/install the app which was previously showing error.
Another Safe way to Fix the Problem: copying to new sheet changes dates in column??:
How to Fix copying to new sheet changes dates in column?? with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your computer. The junk files will be shown in the list.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.18.104.22.16886,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.22.214.171.1240,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.126.96.36.1999,Method to Update & Download ASUS K41VD Intel INF Update Driver v.188.8.131.525,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How Can I Fix - Continuing text past section break?,How to Fix - Convert Dynamic Disk to Basic?,Troubleshooting:Connectivity issue with update KB2909921 Error,Tech Support: cuando abro mi correo sale un cartel amarillo que dice: Windows live no está disponible temporalmente. Vuelva a intentarlo en unos minutos.,Fast Solution to Problem: Creating and Saving Cover Page,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly