I have office loaded on my Mac. I work with a variety of spreadsheets and different applications like Open Office, Access, Excel. Most of my data comes from applications on the PC side. When using Office for Mac, I open a new Excel spread sheet and copy and paste data from one of the other applications. So I have a column of dates in Open Office, I copy the date column and paste into Office for Mac Excel. When I do this the dates change by plus or minus 4 years. So if I move data labeled 10/8/2010 when I paste it into Office for Mac Excel I get 10/8/2014 or 10/8/2006. Sometimes I even get a different month or day along with the plus or minus 4 years on the year.
Any ideas on what is causing this or how I can fix it?
When I move the data into Office for PC Excel I don't have the problem. The dates copy over just fine.
I am not using date formulas or functions. It is simply dates put into the column that I am trying to copy into a single spreadsheet.
Thanks
Any ideas on what is causing this or how I can fix it?
When I move the data into Office for PC Excel I don't have the problem. The dates copy over just fine.
I am not using date formulas or functions. It is simply dates put into the column that I am trying to copy into a single spreadsheet.
Thanks