Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default

yes
I just tried playing with this in Excel 2008.

Go to excel: preferences: calculations and there will be a checkbox with 'use the 1904 date system'. If your 2 sheets are different it will chance the dates when u cut and paste.

I got around this by cutting my data to a new spreadsheet and copying it all. then changing the preference to 'use the 1904 date system' to match the 2nd sheet i need to copy the data to. Then you do 'paste special' (u bring up this menu using alt-right click on the mac or in edit menu also).

in here select paste as 'unicode text'. this will give u your data unchanged but with the correct date mode. u can then copy and paste it across to your 2nd excel sheet without problem.
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
Copy from one Sheet and paste on another sheet based on condition Prem Excel Discussion (Misc queries) 2 December 24th 07 05:05 AM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
when i move or copy a sheet, dates change by one day?? Devo Excel Discussion (Misc queries) 2 February 5th 06 03:01 PM
Copy and paste text and dates Kitty Excel Discussion (Misc queries) 5 March 15th 05 11:03 PM
Why does Excel Copy and Paste change dates from the original when. Excel changes dates in copy and paste Excel Discussion (Misc queries) 5 January 26th 05 05:08 PM


All times are GMT +1. The time now is 12:06 AM.

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

About Us

"It's about Microsoft Excel"