| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Date - weird behavior
I copied a cell containing dates to a new workbook and the date changes by 1
day and the year changes from 2006 to 2003. For example I have 1/20/2006 and the new workbook shows 1/19/2003. I looked at the cell formats and I see that it's a date with an "*" in front of the format. Anyone knows why? How can I fix it so that it copies and pastes correctly. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weird macro behavior | Excel Discussion (Misc queries) | |||
| Weird worksheet saving behavior | Excel Discussion (Misc queries) | |||
| Excel weird behavior | Excel Discussion (Misc queries) | |||
| Strange copy & paste behavior | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Threaded Mode
