Posted to microsoft.public.excel.misc

E[_2_]

external usenet poster

Posts: 40

Dates changing

I am copying a date from one file to another. The date is 01/01/2009, with
date number 39814. When I copy this to the other file the number is still
39814, but the date appears as 02/01/2013. Please could you explain why the
date has changed when I cannot see a difference, and recommend how I can fix
this.

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
Stop UK-style dates changing to US-style dates when mailmerging.	Jean XO	Excel Discussion (Misc queries)	1	December 20th 07 12:35 PM
changing dates.	chesty	Excel Worksheet Functions	1	June 14th 06 03:04 PM
Changing dates using a formula	natys	Excel Discussion (Misc queries)	1	April 13th 06 02:48 PM
Changing Dates	JohnG	Excel Discussion (Misc queries)	1	May 17th 05 08:15 PM
Changing Dates	JohnG	Excel Discussion (Misc queries)	2	May 17th 05 06:22 PM

All times are GMT +1. The time now is 05:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us