Excel problem when copying and pasting

homesick1337

Computer Lover
Joined
20 Jan 2004
Messages
129
Excel Question:

Why is it when I copy my work from one excel document with dates in it. Along with other things i.e currency using the copy command it pastes the wrong dates in the field.

I.E 3/2/07 becomes 3/1/02 Whats more weird is both spreedsheets retain the same formula yet the date is total different even with the same formula. I got no clue why.


But when I copy then paste in notepad then paste in excel theres no problem.


Sorry just a weird question for you excel experts. I don't understand the reason for this.
 

kcnychief

??? ??? ?
Political Access
Joined
8 Apr 2005
Messages
16,950
Based off of what you said, it seems to be taking some formatting with it that it shouldn't? Doesn't make much sense, but I do use Notepad a lot for just the reason you describe. For example, when copying/pasting something from a website, document, spreadsheet whatever - I always go to Notepad first to strip the formatting and attributes. If it works after you go through Notepad, I think something is coming that messes with your new spreadsheet.

Something to try, instead of a straight CTRL + V I am pretty sure there is something like a "Paste Special" in Excel

Read this -

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=40
 

Members online

No members online now.

Latest forum posts

Latest profile posts

Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,414
Members
5,591
Latest member
nodee