I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and
"0.01". I have no idea why it's doing that. I've looked under "format
cells" but I can't figure out what's wrong. Help me please! Thanks!
I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and
"0.01". I have no idea why it's doing that. I've looked under "format
cells" but I can't figure out what's wrong. Help me please! Thanks!
You have the 'fixed decimal' setting turned on. You should see
'Fix" 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 "Fixed decimal".
"Zzilly14" <Zzilly14@discussions.microsoft.com> wrote in message
news:B767A008-B95B-4D38-99DE-32E232636F18@microsoft.com...
>I need help! When I enter numbers, like "-2" or "1", they
>become "-0.02" and
> "0.01". I have no idea why it's doing that. I've looked under
> "format
> cells" but I can't figure out what's wrong. Help me please!
> Thanks!
Tools|options|edit tab|uncheck fixed decimal places
Zzilly14 wrote:
>
> I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and
> "0.01". I have no idea why it's doing that. I've looked under "format
> cells" but I can't figure out what's wrong. Help me please! Thanks!
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks