Posted to microsoft.public.excel.worksheet.functions

David

external usenet poster

Posts: 1,560

Copying Date and pasting special - DATE CHANGES?!?

I am copying from one sheet and pasting special (format and value) to another
sheet. When I do, the date changes.

I've converted the date to a general number -
40193 -

In the source sheet it shows as 1/15/10
In the destination sheet it shows as 1/16/14

How can I get this cleared up?
Anyone?

Thank you!!

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
getting date in special form	Totti	New Users to Excel	3	October 14th 08 11:16 PM
Special Date Function	Christopher D	Excel Worksheet Functions	1	September 10th 08 07:06 PM
Copy pasting and reformat Date	whatzzup	Excel Discussion (Misc queries)	2	April 28th 08 08:45 PM
Pasting #-# as text and not a date	lcshrm	Excel Discussion (Misc queries)	5	March 16th 07 03:12 AM
date conversion after pasting	DC Gringo	Excel Worksheet Functions	2	February 16th 06 06:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us