| 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. |
| 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) | |||
Threaded Mode
