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

You merely have to select the cells in the column A and format them for
dates, and then select the cells in column C and format them for Time. The
numbers that you're seeing are the date and time serial values respectively.
--
Kevin Backmann


"Josh" wrote:

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

Thank you, Kevin.
--
Josh


"Kevin B" wrote:

You merely have to select the cells in the column A and format them for
dates, and then select the cells in column C and format them for Time. The
numbers that you're seeing are the date and time serial values respectively.
--
Kevin Backmann


"Josh" wrote:

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

I have the same problem, and formatting these numbers as dates does not help.

When I select the cell with a number, the edit bar shows the date I entered
in the desired format: 3-10-06.

So the data is there, but I can't display it in date format. Why doesn't
this work?


"Josh" wrote:

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