close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()