Hi,

When posting dates you need to make it clear what they are. Your posted
dates/times:-

9/5/06 2:00 PM (Date in Original Sheet)
9/6/10 2:00 PM (Date after copying/pasting)

In the date part every number is < 12 so we can have no idea what they are.
For example the first date

9 May 06?
5 Sep 06?
or even some sort of custom date of y/m/d.

What do you see in the formula bar when you select the date for copying, is
it =NOW() or something else?

Mike

"Neon520" wrote:

Hi Everyone,

One quick question about why the in my spreadsheet change after copying and
pasting to a new workbook.

9/5/06 2:00 PM (Date in Original Sheet)
9/6/10 2:00 PM (Date after copying/pasting)

Does anyone know how this happen?

Thank you,
Neon520