CELL/NUMBER FORMAT

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?
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Number Outlook Merge 1
Help with fixed decimal 4
Number Format Problem 2
Decimal points data not displaying as expected 2
Error Message 2
Default number format in Excel 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
A non roundup decimal place cell format 6

Top