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??
Devo
Go to Toolsgt;Optionsgt;Calculation and uncheck 1904 date system
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.ukquot;Devoquot; gt; wrote in message
...
gt;I have workbook with mutiple sheets, When I move or copy a sheet to a new
gt; book, all the dates change by negative one day. What's up??
quot;Nick Hodgequot; wrote:
gt; Devo
gt;
gt; Go to Toolsgt;Optionsgt;Calculation and uncheck 1904 date system
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt;
gt;
gt; quot;Devoquot; gt; wrote in message
gt; ...
gt; gt;I have workbook with mutiple sheets, When I move or copy a sheet to a new
gt; gt; book, all the dates change by negative one day. What's up??
gt;
gt;
gt; That's got it!!!
Thanks a lot!!
Regards;
Devo
- Aug 07 Thu 2008 20:45
when i move or copy a sheet, dates change by one day??
close
全站熱搜
留言列表
發表留言