View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default dates vary in a copied sheet

Jeannie

Sounds like you are on the 1904 date system. This can be changed by either
you or the recipient of your workbook at (pre 2007) Toolsoptionscalculation
tab & change the setting for th 1904 date system. This change will affect
otgher workbooks, so be careful.

Mike Rogers

"Jeannie" wrote:

emailed a file and dates on sheet they see are exactly 1 day and 4 years
earlier than actual dates shown on my sheet.
--
JeannieC