Excel cut/Paste Problem: Year changes after data is copy and paste

Asif · 12-08-2005, 06:40 PM

I am using Excel 2003, and here is the problem. I have an Excel sheet that
contains financials. Different departments need different sections of the
data, so I copy and paste out only those sections they need and paste it into
a new Excel sheet. The colums are broken up into dates, and formated to show
date-year (Dec-05). For some reason, when I copy and paste sections, the date
will change, for example Dec-05 will change to Dec-01. I have to go thru and
manually correct all the dates. Can anyone tell me what is causing this?

**Agent C** · 12-08-2005, 06:53 PM

.

.. maybe the cells in the New worksheet are preset to a certain format. I would check the settings in the new worksheet before actually pasting. If necessary, match it against the settings of the old (copied) worksheet.

.. and make sure of the actual Data that you are copying .. not just the displayed data. (ie/ Dec-05 could be 12/01/2005 or it could be 12/2005/01).

.. check the cell range formatting before pasting.

.

Gord Dibben · 12-08-2005, 08:50 PM

Asif

One of the workbooks was saved using the Tools>Options>Calculation>1904 date
system.

The other is using the standard Excel date system.

Looks like source wookbook is using 1904 system.

I would uncheck that option in source book unless there is a compelling reason
to leave it on 1904 date system..

This will change the dates by 4 years and a day.

To resolve this, enter 1462 in an empty cell and copy it then select the dates
and paste special>add>OK>Esc.

Re-format to your preferred date format.

Now copy over to the target workbook.

Gord Dibben Excel MVP

On Thu, 8 Dec 2005 14:35:04 -0800, "Asif" <[email protected]>
wrote:

>I am using Excel 2003, and here is the problem. I have an Excel sheet that
>contains financials. Different departments need different sections of the
>data, so I copy and paste out only those sections they need and paste it into
>a new Excel sheet. The colums are broken up into dates, and formated to show
>date-year (Dec-05). For some reason, when I copy and paste sections, the date
>will change, for example Dec-05 will change to Dec-01. I have to go thru and
>manually correct all the dates. Can anyone tell me what is causing this?

Asif · 12-09-2005, 01:20 PM

Thank you very much, I will try that and see if it works.

Thanks

"Gord Dibben" wrote:

> Asif
>
> One of the workbooks was saved using the Tools>Options>Calculation>1904 date
> system.
>
> The other is using the standard Excel date system.
>
> Looks like source wookbook is using 1904 system.
>
> I would uncheck that option in source book unless there is a compelling reason
> to leave it on 1904 date system..
>
> This will change the dates by 4 years and a day.
>
> To resolve this, enter 1462 in an empty cell and copy it then select the dates
> and paste special>add>OK>Esc.
>
> Re-format to your preferred date format.
>
> Now copy over to the target workbook.
>
>
> Gord Dibben Excel MVP
>
> On Thu, 8 Dec 2005 14:35:04 -0800, "Asif" <[email protected]>
> wrote:
>
> >I am using Excel 2003, and here is the problem. I have an Excel sheet that
> >contains financials. Different departments need different sections of the
> >data, so I copy and paste out only those sections they need and paste it into
> >a new Excel sheet. The colums are broken up into dates, and formated to show
> >date-year (Dec-05). For some reason, when I copy and paste sections, the date
> >will change, for example Dec-05 will change to Dec-01. I have to go thru and
> >manually correct all the dates. Can anyone tell me what is causing this?
>