Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Dates change to prior year when page moved to new book

ToolsOptionsCalculation, make sure that "1904 date system" is the same in
both books

--
Kind regards,

Niek Otten


"David_UCSF" wrote in message
...
Excel 2003. I have columns containing dates in 2004 and 2005. When I move
or
copy the page to a new book, all of the dates change to 2000 and 2001. How
do
I correct so that the page can be moved or copied?



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
master select page field for many pivots in one work book Todd F. Excel Discussion (Misc queries) 0 August 16th 05 08:00 PM
Can I change a column of dates from USA to UK format? Michelle, Mencap Excel Discussion (Misc queries) 3 March 2nd 05 04:02 PM
In Excel spreadsheeet the dates change to the wrong date after we. ziptozipper Excel Discussion (Misc queries) 1 February 2nd 05 02:22 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
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:21 PM


All times are GMT +1. The time now is 05:42 PM.

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"