CELL/NUMBER FORMAT

  • Thread starter Thread starter BIBBYBIBBER
  • Start date Start date
B

BIBBYBIBBER

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 Tools>Options>Edit, and if the Fixed Decimal box is checked, uncheck
it.

--

HTH

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