LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Wrong Date when pasting/linking workbooks

Hi.

I really hate to bother you with this, but . . . .

I am linking two existing workbooks. All is fine, until I try to link the
Date of an action.

Both the origin and the linked cells are formated dd-mmm-yyyy, one of the
available date formats. But, when I enter 15 Mar 2008 in the source, it
shows up as 14 Mar 2004. I did notice that in the Format Cell Date options,
the listed formats were also one year and one day off from each other in the
different workbooks.

Both workbooks are currently opened on my desktop using the only version of
EXCEL on the machine, EXCEL 2003 SP3.

Any advice or words of encouragement are appreciated.
--
JP Cummings
 
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
Macro linking to wrong workbook Tim879 Excel Discussion (Misc queries) 2 August 31st 07 03:36 PM
linking 12 monthly workbooks to one year to date workbook John Excel Worksheet Functions 1 January 23rd 07 04:52 PM
Need assistance linking workbooks by date bsmith Excel Worksheet Functions 2 November 19th 05 08:26 PM
Copying and Pasting between Workbooks NothingButRomance Excel Worksheet Functions 0 May 13th 05 09:54 PM
Copying and Pasting between Workbooks NothingButRomance Excel Worksheet Functions 0 May 13th 05 07:33 PM


All times are GMT +1. The time now is 01:36 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"