close

I have a strange problem, I open up a blank spreadsheet and if I type in
2004 in a cell, it will automatically change it to 2005. There are no
formulas on the cell or anything, and no matter where I type 2004 it
changes it. This only happens with 2004 as far as I can tell, it
doesn't have a problem with any other years previous. I re-installed
excel and the problem persists. Any guidance is appreciated, I'm hoping
it's a simple fix --
archergirl2000
------------------------------------------------------------------------
archergirl2000's Profile: www.excelforum.com/member.php...oamp;userid=34462
View this thread: www.excelforum.com/showthread...hreadid=542248Have you tried going to TOOLS in the menu, selecting AUTO-CORRECT OPTIONS and
verifying that 2004 is not set to be replaced by 2005
--
Kevin Backmannquot;archergirl2000quot; wrote:

gt;
gt; I have a strange problem, I open up a blank spreadsheet and if I type in
gt; 2004 in a cell, it will automatically change it to 2005. There are no
gt; formulas on the cell or anything, and no matter where I type 2004 it
gt; changes it. This only happens with 2004 as far as I can tell, it
gt; doesn't have a problem with any other years previous. I re-installed
gt; excel and the problem persists. Any guidance is appreciated, I'm hoping
gt; it's a simple fix
gt;
gt;
gt; --
gt; archergirl2000
gt; ------------------------------------------------------------------------
gt; archergirl2000's Profile: www.excelforum.com/member.php...oamp;userid=34462
gt; View this thread: www.excelforum.com/showthread...hreadid=542248
gt;
gt;

archergirl2000, I would take a look at tools, autocorrect and see if there
is a 2004 to be replaced with 2005
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;archergirl2000quot;
lt;archergirl2000.27v6cn_1147722001.5692@excelforu m-nospam.comgt; wrote in
message news:archergirl2000.27v6cn_1147722001.5692@excelfo rum-nospam.com...
gt;
gt; I have a strange problem, I open up a blank spreadsheet and if I type in
gt; 2004 in a cell, it will automatically change it to 2005. There are no
gt; formulas on the cell or anything, and no matter where I type 2004 it
gt; changes it. This only happens with 2004 as far as I can tell, it
gt; doesn't have a problem with any other years previous. I re-installed
gt; excel and the problem persists. Any guidance is appreciated, I'm hoping
gt; it's a simple fix
gt;
gt;
gt; --
gt; archergirl2000
gt; ------------------------------------------------------------------------
gt; archergirl2000's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34462
gt; View this thread: www.excelforum.com/showthread...hreadid=542248
gt;

Yes that was it! Thanks so much --
archergirl2000
------------------------------------------------------------------------
archergirl2000's Profile: www.excelforum.com/member.php...oamp;userid=34462
View this thread: www.excelforum.com/showthread...hreadid=542248

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

    software

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