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!!