EXCEL. When entering a whole number into a cell EXCEl is dividing
that number by 10 immediatly after entry. If I place a decimal point
after the number this does not happen. If I enter a number less than 1
the number is entered normally. It appears that EXCEL needs a decimal
point to enter the number correctly. I have used EXCEL for many years
(current version from 2004) and this has never hapenned. Any Ideas out
there guys?

Sounds like Fixed Decimal is set.

Go to ToolsOptionsEdit, and if the Fixed Decimal box is checked, uncheck
it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BIBBYBIBBER" wrote in message
ups.com...
EXCEL. When entering a whole number into a cell EXCEl is dividing
that number by 10 immediatly after entry. If I place a decimal point
after the number this does not happen. If I enter a number less than 1
the number is entered normally. It appears that EXCEL needs a decimal
point to enter the number correctly. I have used EXCEL for many years
(current version from 2004) and this has never hapenned. Any Ideas out
there guys?

THANKS SO MUCH!!

You are right on !

THANKS SO MUCH!!

You are right on !

THANKS SO MUCH!!

You are right on !

THANKS SO MUCH!!

You are right on !