Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 8th 05, 11:35 PM posted to microsoft.public.excel.misc
Asif
 
Posts: n/a
Default Excel cut/Paste Problem: Year changes after data is copy and paste

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?

  #2   Report Post  
Old December 9th 05, 01:45 AM posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Excel cut/Paste Problem: Year changes after data is copy and paste

Asif

One of the workbooks was saved using the ToolsOptionsCalculation1904 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 specialaddOKEsc.

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"
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?

  #3   Report Post  
Old December 9th 05, 06:16 PM posted to microsoft.public.excel.misc
Asif
 
Posts: n/a
Default Excel cut/Paste Problem: Year changes after data is copy and p

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 ToolsOptionsCalculation1904 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 specialaddOKEsc.

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"
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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
For Excel 2003: Is there a way to copy and paste a row of data to. Marketing Grrrl Excel Discussion (Misc queries) 1 April 18th 05 08:36 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 03:04 AM
How do i copy columns of data in notepad into excel? JJ Excel Discussion (Misc queries) 1 February 10th 05 10:21 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 10:20 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017