I'm trying to copy all the data from an existing workbook into a new
workbook that isn't autoformatted. I copy and paste, but the columns for
dates and times display totally changed data in the new workbook. For
example, in A5:A10 and C5:C10 I originally had
column
row A b c
5 1/3/2003 x 11:00 AM
6 1/3/2003 x 2:00 PM
7 1/3/2003 x 2:00 PM
8 1/6/2003 x 11:00 AM
9 1/6/2003 x 10:00 AM
10 1/6/2003 x 10:00 AM
and in the new workbook the copied info appears
column
row a b c
5 37624 x 0.4583333
6 37624 x 0.5833333
7 37624 x 0.5833333
8 37627 x 0.4583333
9 37627 x 0.4166667
10 37627 x 0.4166667
What's going on? Am I performing some sort of calculation that doesn't
recognize these data as dates and times? Why isn't it copying exactly what
appears in the original workbook? Thanks for any and all help.
--
Josh
Bookmarks