CELL/NUMBER FORMAT
 

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?

CELL/NUMBER FORMAT
 

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?

CELL/NUMBER FORMAT
 

THANKS SO MUCH!!

You are right on !

CELL/NUMBER FORMAT
 

THANKS SO MUCH!!

You are right on !

CELL/NUMBER FORMAT
 

THANKS SO MUCH!!

You are right on !

CELL/NUMBER FORMAT
 

THANKS SO MUCH!!

You are right on !