|
|
|
|
#1
04-01-2016, 05:40 PM
|
||||
|
||||
the simple reason for this is that the source workbook uses the Mac 1904 system date base, whilst the target workbook uses the PC 1900 date base. See under File|Options|Advanced>When calculating this workbook>Use 1904 date system.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Wow! Excel for Mac 2016: SLOW AND BUGS! | Russk68 | Excel | 0 | 01-24-2016 11:54 PM |
 Problem with Microsoft Excel 2016
|
akkha | Excel | 1 | 11-20-2015 09:37 PM |
| Excel problems since using Office 365 especially since 2016 | USAOz | Excel | 0 | 11-10-2015 09:06 PM |
|
Unusual issue
|
jeffreynya | Outlook | 4 | 04-14-2011 08:48 AM |
| unusual word problem | reuhaj | Word | 0 | 03-07-2009 05:16 AM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode