Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I extract the moving average trendline point data? | Charts and Charting in Excel | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Moving Data from Template | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) |