Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Why is Excel changing day & date data when I copy & paste? When I highlight
and copy a range of cells and paste into another sheet, in one column only the dates of the material being copied (expressed as 1/23/4567) change. A cursory examination seems to indicate a pattern of a one-day and four-year change in each cell; e.g. 5/12/2005 becomes 5/13/2009. There have been some variations of this where the day apparently stays the same but the year goes back 4 years, e.g. 2006 becomes 2002. During the same operation, although both sheets are in Arial font, the font of all the material being copied is changed to Verdana upon being pasted. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |