View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sweepea Sweepea is offline
external usenet poster
 
Posts: 28
Default Date Cut & Paste Issue

Example:

Original text: 4/28/2004

After cut and paste, it changes to: 4/29/2008




"Gary''s Student" wrote:

Post a single example. It may help us figure it out.
--
Gary''s Student


"Sweepea" wrote:

The date changed to a totally different day and year.

Any clue?

"Sweepea" wrote:

Question:

I cut and paste Value a date onto another area, and format that date
to Date format, but it's showing a different date.

Can someone help? Thanks a lot.