Why do dates change when pasting in excel

Dates change when cut and pasted. Register To Reply. Re: Dates change when cut and pasted. One test is worth a thousand opinions. Re: Dates change when cut and pasted From you answers there must be a difference in the versions of Excel from one sheet to the next. Is one of the sheets very old and using date formats from Excel pre 95? Also look at your system settings to see if your date is set correctly. In reply to laurenlee's post on May 25, The default date system in Excel starts at January 1, You can change the date system for the active workbook as follows: Click the Office button.

Click Excel Options. Click Advanced. In the section "When calculating this workbook", tick or clear the check box "Use date system". Clear it for optimal compatibility with workbooks created in Windows Click OK. How satisfied are you with this reply? A subscription to make the most of your time. The Most simple way. Copy the original Data 2. Copy All from Notepad 5. Paste back to Excel. Shiro Shiro 5 5 gold badges 10 10 silver badges 27 27 bronze badges. OK, so for million cells you do it million times?

U can select the whole column from the top. It will select all, and copy and paste to the notepad. This works! Select the whole sheet, format as text, paste! Excel is stupid. However, your solution is the only one that consistently works. Now, go ahead and paste, but paste using the 'match the destination formatting' option. This does not work for me. For formatting, "Text" works and "General" doesn't work. The detail I missed. Thanks Paul.

Sandy Spence Sandy Spence 31 1 1 bronze badge. Select all the cells, and change their format to Text. Sammy Larbi Sammy Larbi 2 2 bronze badges. EL EL Unfortunatelly, it perverses other data And it should be "transition formula entry" instead..

This is a bit of a kluge, but if the data can be pasted normally without using Paste Special it usually works: Format all empty cells where dates will fall as text. Right-click when pasting and select "Match destination formatting. Benjamin Morris Benjamin Morris 11 1 1 bronze badge. Ruchi Ruchi 1 1 bronze badge. Because I'm pasting html content. Jerry C Jerry C 1. Select all and format the cells as text 3. Paste original clipboard object again over what you did the first time - But this time select "Paste Special The Overflow Blog.

Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked 6.