Why does Excel Copy and Paste change dates from the original when.

G

Guest

When copying and pasting dates, Excel pastes strange dates. Where do these
come from and how do I stop this from occurring?
 
G

Gord Dibben

Copy and paste from where to where?

Perhaps the "dates" you are copying are Text and not real dates.

Give an example of a "strange date".


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop the "flashing" when I execute an Excel macro? 4
fractions turn into dates when pasting in excel 2003 5
Pasting dates from one spreadsheet to another 2
Copy and Paste 2007 1
Defaulting to date format 4
Issue with dates being pasted correctly 2
Copying Dates 1
Excel flags cells 1

Top