when i move or copy a sheet, dates change by one day??
 

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??

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??

when i move or copy a sheet, dates change by one day??
 

"Nick Hodge" wrote:

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??


That's got it!!!

Thanks a lot!!

Regards;
Devo