close

I have a worksheet that turns all numbers with an operator into a formula.
For instance when I enter quot;4/11/06quot; it changes it to quot;=4/11/06quot;. This is
regardless of what the cell format is, date, general, etc. I can create
another worksheet in this workbook and this does not occur. I can get around
this problem, but there is something tied to this particular sheet that
changes what is entered and I would like to find it.
Any help out there?

This is Excel 2003

Toolsgt;optionsgt;transition uncheck transition formula entry, it is for
compatibility with Lotus 123--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Matt Mahanquot; lt;Matt gt; wrote in message
...
gt;I have a worksheet that turns all numbers with an operator into a formula.
gt; For instance when I enter quot;4/11/06quot; it changes it to quot;=4/11/06quot;. This is
gt; regardless of what the cell format is, date, general, etc. I can create
gt; another worksheet in this workbook and this does not occur. I can get
gt; around
gt; this problem, but there is something tied to this particular sheet that
gt; changes what is entered and I would like to find it.
gt; Any help out there?
gt;
gt; This is Excel 2003

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

    software

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