Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep date from incrementing on paste to new workbook?
I'm on a MacPro (Intel) using Office:Mac 2004: Student and Teacher Edition.
I'm trying to copy a *large* selection from one workbook that has dates in one column to another workbook. Unfortunately on paste, it's incrementing it four years. Ack! No! It's not a formula, it's just a number formatted as a date. I have tried paste, paste special-all, paste special-values, paste special-values and number formats. I have gone into preferences ("properties" to you PC folks) and dug around in there to see if there's anything I need to turn off or on. I've hit a wall. Can anyone help me, please? I have to have this report ready for my board of directors tomorrow night and I can't get this to work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep date from incrementing on paste to new workbook?
hi
i suspect that you are pasting into a pc that using a different date system. there are two. 1900 date system and 1904 date system. switching systems throws the dates off by four years and one day. see this site for more info and a possible fix..... http://support.microsoft.com/kb/180162 regards FSt1 "trixiesirisheyes" wrote: I'm on a MacPro (Intel) using Office:Mac 2004: Student and Teacher Edition. I'm trying to copy a *large* selection from one workbook that has dates in one column to another workbook. Unfortunately on paste, it's incrementing it four years. Ack! No! It's not a formula, it's just a number formatted as a date. I have tried paste, paste special-all, paste special-values, paste special-values and number formats. I have gone into preferences ("properties" to you PC folks) and dug around in there to see if there's anything I need to turn off or on. I've hit a wall. Can anyone help me, please? I have to have this report ready for my board of directors tomorrow night and I can't get this to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop formulas from incrementing when you copy and paste? | Excel Worksheet Functions | |||
Incrementing the date | Excel Discussion (Misc queries) | |||
Copy cells from one worksheet and paste to incrementing sheets? | Excel Discussion (Misc queries) | |||
incrementing a date that the user has entered? | Excel Worksheet Functions | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |