| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does the date change when copying?
Files that I created on a mac I am now accessing on a pc, whenever I go to
copy and paste a date from one of these files into a new document spreadsheet the dates change. They go back in time 4 years and one day. This is very frustrating, I have checked the 1904 box in the tools option calculation tab and the dates go to what they should be but then all the new dates that I had entered in that new file go ahead four years and 1 day. I work in a research medical center and I can't have dates changing, I need accuracy. Please can you help with this problem |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does the date change when copying?
Click the next to last link:
http://support.microsoft.com/default.aspx/kb/214094 -John "Jessica" wrote: Files that I created on a mac I am now accessing on a pc, whenever I go to copy and paste a date from one of these files into a new document spreadsheet the dates change. They go back in time 4 years and one day. This is very frustrating, I have checked the 1904 box in the tools option calculation tab and the dates go to what they should be but then all the new dates that I had entered in that new file go ahead four years and 1 day. I work in a research medical center and I can't have dates changing, I need accuracy. Please can you help with this problem |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does the date change when copying?
Jessica
I would not change the options in the Excel workbook. Enter 1462 in an unused cell. Copy that cell. Select the incorrect MAC-dumped dates and EditPaste SpecialAddtOKEsc. Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 12:16:01 -0800, Jessica wrote: Files that I created on a mac I am now accessing on a pc, whenever I go to copy and paste a date from one of these files into a new document spreadsheet the dates change. They go back in time 4 years and one day. This is very frustrating, I have checked the 1904 box in the tools option calculation tab and the dates go to what they should be but then all the new dates that I had entered in that new file go ahead four years and 1 day. I work in a research medical center and I can't have dates changing, I need accuracy. Please can you help with this problem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Linear Mode
