View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 1
Default HELP! DATE FORMATTING CRISIS!


Excel has two date settings. Looks like your source workbook uses the
1904 date system, whilst the second uses the default 1900 date system.
Change one by using

Tools Options Calculation and checking/unchecking as necessary
"1904 date system"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=574132