Posted to microsoft.public.excel.misc

kmp28385

external usenet poster

Posts: 1

Problem with copying dates between files

I'm trying to copy a column of dates in one file to another file in Excel
2003. When I copy the column to the new file the dates are changed. For
example, the original cell in file A reads "06/09/97" for June 9, 1997. When
I copy that cell to file B the copied cell reads "06/08/93". Why is Excel
changing the dates and how can I fix it? Any advice would be greatly
appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Problem copying dates	iontrap	Excel Discussion (Misc queries)	3	December 6th 06 04:58 PM
Copying Dates	nitsa	Excel Discussion (Misc queries)	2	July 4th 06 03:45 PM
Copying linked Excel Files	ScottH	Excel Discussion (Misc queries)	0	March 9th 06 08:22 PM
Copying files	fds	Excel Worksheet Functions	1	July 27th 05 12:55 AM
When copying dates to another sheet the dates are different	Kelly C	Excel Worksheet Functions	1	January 12th 05 12:39 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us