View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default when i move or copy a sheet, dates change by one day??

Devo

Go to ToolsOptionsCalculation and uncheck 1904 date system

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"Devo" wrote in message
...
I have workbook with mutiple sheets, When I move or copy a sheet to a new
book, all the dates change by negative one day. What's up??