close

I need help! When I enter numbers, like quot;-2quot; or quot;1quot;, they become quot;-0.02quot; and
quot;0.01quot;. I have no idea why it's doing that. I've looked under quot;format
cellsquot; but I can't figure out what's wrong. Help me please! Thanks!

You have the 'fixed decimal' setting turned on. You should see
'Fixquot; in the bottom right corner of the Excel screen. To turn
this off, go to the Tools menu, choose Options, then the Edit
tab. There, uncheck quot;Fixed decimalquot;.quot;Zzilly14quot; gt; wrote in message
...
gt;I need help! When I enter numbers, like quot;-2quot; or quot;1quot;, they
gt;become quot;-0.02quot; and
gt; quot;0.01quot;. I have no idea why it's doing that. I've looked under
gt; quot;format
gt; cellsquot; but I can't figure out what's wrong. Help me please!
gt; Thanks!
Tools|options|edit tab|uncheck fixed decimal places
Zzilly14 wrote:
gt;
gt; I need help! When I enter numbers, like quot;-2quot; or quot;1quot;, they become quot;-0.02quot; and
gt; quot;0.01quot;. I have no idea why it's doing that. I've looked under quot;format
gt; cellsquot; but I can't figure out what's wrong. Help me please! Thanks!

--

Dave Peterson

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

    software

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