| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy from one worksheet to another changes the year from 2009 to 2
Formatting of the first worksheet is custom d/mm/yyyy hh:mm. But when the
cell is copied and pasted to a new worksheet the year changes from 2009 to 2013. I'm running Excel 2007 (Office 2007 SP 2 12.0.6514.5000) and Windows 7. Have just upgraded to Win . I've never experienced this problem with dates before! Cant seem to find any info about what may be causing this. Any assistance appreciated. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IN EXCEL, TO CENTER & UNDERLINE A YEAR (ie: 2009), NOT "2,009"? | Excel Discussion (Misc queries) | |||
| How do I copy a worksheet for each day of the year? | Excel Discussion (Misc queries) | |||
| How create 365 labels for 2009? Example: Monday, Jan. 4, 2009 | Excel Discussion (Misc queries) | |||
| Cell won't accept date past year 2009 | New Users to Excel | |||
| Excel cut/paste prob: Adds one day and changes year to 2009 | Excel Discussion (Misc queries) | |||
Threaded Mode
