Date copy/paste problem

libada

Estimable
Nov 6, 2014
7
0
4,510
0
I am using Excel 13 on Windows 7. Usually copying a worksheet is not a problem. However, on one worksheet I receive from a client (which contains dates, formatted with the custom format d,mmm), when I try to copy/paste it, all dates are changed on the new copy to one date earlier than they were on the original. None of the date cells are formulas. I have tried every way of "paste special" I can think of. Why is this happening? Is the worksheet corrupt?

All other sheets I copy which contain dates copy just fine.

Thank you.
 
G

Guest

Guest
little confused by what you mean by "all dates are changed on the new copy to one date earlier than they were on the original"

can you clarify?

also - excel 13? Excel 2013, yes?
 

libada

Estimable
Nov 6, 2014
7
0
4,510
0


If the date on the original is November 6, 2014, appearing in the cell as "6-Nov" when I copy it to the new sheet, it changes to "5-Nov" for no apparent reason.
 

libada

Estimable
Nov 6, 2014
7
0
4,510
0


Sorry - And yes, Excel 2013. My bad.
 

libada

Estimable
Nov 6, 2014
7
0
4,510
0


The correct date, i.e. if the date in the cell on the original is November 6, 2014, appearing as "6-Nov" it appears the same way when pasted into notepad.
 

JeckeL

Distinguished
Jul 19, 2009
224
1
18,910
41


What kind of format is the destination cell in excel 2013 (i.e. date, general, text, etc), and if you change the format type of the original cell (which is a custom '6-Nov' date) to short date do you get 11/6/2014? Is the time & date set correctly on your PC?
 

USAFRet

Illustrious
Moderator
Is the client possibly in a different time zone?
5 Nov 2014 11 AM in New York is 6 Nov 2014 1:00 AM in Tokyo.

Excel doesn't store the 'date'. It stores the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day.
It then presents it to you in date format, relative to your time zone.
 

libada

Estimable
Nov 6, 2014
7
0
4,510
0


Unfortunately, the client is in the same time zone as we are. Interesting information, though. Thank you.
 

libada

Estimable
Nov 6, 2014
7
0
4,510
0


The destination cell is formatted by copying through "Paste, special, format and number values." If I change the format type of the original cell to show 11/6/2014, then try to copy/paste, the destination cell then shows 11/6/2010. Crazy. Yes, date, time and time zone are all set correctly on my PC.
 

USAFRet

Illustrious
Moderator


Mac vs PC. See above.
 

libada

Estimable
Nov 6, 2014
7
0
4,510
0



Ah, another interesting piece of useful information. And yes, quite confusing and frustrating. What an odd place to start! Thank you for the info.
 
Thread starter Similar threads Forum Replies Date
FireFighter1215 Apps General Discussion 2
L Apps General Discussion 1
D Apps General Discussion 2
R Apps General Discussion 1
T Apps General Discussion 1
T Apps General Discussion 2
D Apps General Discussion 3
V Apps General Discussion 3
S Apps General Discussion 3
M Apps General Discussion 1
J Apps General Discussion 1
N Apps General Discussion 5
T Apps General Discussion 1
J Apps General Discussion 2
A Apps General Discussion 6
A Apps General Discussion 5
M Apps General Discussion 1
F Apps General Discussion 7
E Apps General Discussion 1
jbosari Apps General Discussion 0

ASK THE COMMUNITY