Excel divides by 100

M

Mark P

Hi

I run windows XP and Office 2000 pro. and in the last month excel ha
started this problem

When you enter a an integer number in a cell excel automaticall
divides it by 100 when you press enter. eg: enter 1 you get 0.01

However, if you enter 1. in the cell, you get 1 so it is only makin
the change when I don't specify a decimal number

It is REALLY annoying

Please hel

Cheers

Mar
 
G

garfield-n-odie

In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.
 

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

Excel automatically divides number by 100 3
Excel divides every number I type in by 100 2
Why does an integer entered in the cell divide by 10? 1
Automatic division of all input by 100 2
Excel number format 3
Cell divides by 10 2
Mystical Excel 4
Decimal problems in Excel 2008 (Mac) 1

Top