| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why does Excel Copy and Paste change dates from the original when.
When copying and pasting dates, Excel pastes strange dates. Where do these
come from and how do I stop this from occurring? |
|
#2
|
|||
|
|||
|
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 On Tue, 25 Jan 2005 13:27:04 -0800, "Excel changes dates in copy and paste" <Excel changes dates in copy and wrote: When copying and pasting dates, Excel pastes strange dates. Where do these come from and how do I stop this from occurring? |
|
#3
|
|||
|
|||
|
Me on a Friday night?
(Sometimes, you make it too easy!) Gord Dibben wrote: 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 On Tue, 25 Jan 2005 13:27:04 -0800, "Excel changes dates in copy and paste" <Excel changes dates in copy and wrote: When copying and pasting dates, Excel pastes strange dates. Where do these come from and how do I stop this from occurring? -- Dave Peterson |
|
#4
|
|||
|
|||
|
Oh, I don't think Friday has anything to do with it. <g
Dave Peterson wrote: Me on a Friday night? (Sometimes, you make it too easy!) Gord Dibben wrote: 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 On Tue, 25 Jan 2005 13:27:04 -0800, "Excel changes dates in copy and paste" <Excel changes dates in copy and wrote: When copying and pasting dates, Excel pastes strange dates. Where do these come from and how do I stop this from occurring? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#5
|
|||
|
|||
|
Thank you for your continued support.
Debra Dalgleish wrote: Oh, I don't think Friday has anything to do with it. <g Dave Peterson wrote: Me on a Friday night? (Sometimes, you make it too easy!) Gord Dibben wrote: 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 On Tue, 25 Jan 2005 13:27:04 -0800, "Excel changes dates in copy and paste" <Excel changes dates in copy and wrote: When copying and pasting dates, Excel pastes strange dates. Where do these come from and how do I stop this from occurring? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
|
#6
|
|||
|
|||
|
LOL
Gord On Tue, 25 Jan 2005 19:51:25 -0600, Dave Peterson wrote: Me on a Friday night? (Sometimes, you make it too easy!) Gord Dibben wrote: 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 On Tue, 25 Jan 2005 13:27:04 -0800, "Excel changes dates in copy and paste" <Excel changes dates in copy and wrote: When copying and pasting dates, Excel pastes strange dates. Where do these come from and how do I stop this from occurring? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
| How do I edit, copy and paste text in excel cells? | New Users to Excel | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
| IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF. | Excel Worksheet Functions | |||
Linear Mode
