entering a whole number e.g. 4, results in a decimal entry, 0.04

B

Bluebottle

my excel 2003 suddenly developed the above fault, which try as I may, I
cannot cure. If I enter the number with a decimal point after it, it enters
as the correct whole number. The selfsame programme on my Vista laptop has
not developed the fault (yet, anyway!)
Anyone come across this before? Thanks for your attention,
J.Fulcher
 
D

Dave Peterson

Tools|Options|Edit tab|uncheck Fixed Decimal places.

It's a handy tool for the accountancy types who don't want to enter decimal
points.

It's a pain for the rest of us <vbg>.
 

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 option for decimal. e.g., entering 531 results in 5.31 5
Your entry cannot be used. An integer or decimal number may be required. 4
Entering a date results in a decimal fraction 2
Want Fixed Decimal places in only 1 column 4
text entry in a number field 1
Excel file for deliberations on proper entry date into a retirementplan 1
Generating (in a random order)each number once from a given number 2
some problems in date entry in a web bsed statement 5

Top