The calendar system must be set on 1900 to ensure correct displaying of time values in DDE references.

Microsoft Excel supports two calendar systems: System 1900 and System 1904. In System 1900, DDE Server transports the values of time objects as serial value to MS Excel. The default system is System 1900.
If System 1900 is not set, you must change it.


How to change calendar system to 1900

  1. Choose Options from Tools menu.
  2. Click on Calculation tab.
  3. Tick off 1904 date system in Workbook options.
  4. Then press OK.
Napíšte komentár