My excel spread sheets are dividing all numbers input by 100.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are no formula apparent and this occurs on all new worksheets and even
after reloading the software. The number 3 input appears as 0.03 and so on.
 
You have formatted the cells as percentage. Whatever you input will be
divided by 100.

Change the format of the cells to other than percentage.
 
Tools>Options>Edit.

Uncheck "fixed decimal places".


Gord Dibben MS Excel MVP
 
You have formatted the cells as percentage. Whatever you input will be
divided by 100.

Change the format of the cells to other than percentage.
Click to expand...

I think you'll find that formatting as percentage will MULTIPLY by 100, not
divide, Rick.

Gord's suggestion (Fixed decimals) is the usual cause of these symptoms.
 
You must log in or register to reply here.

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

Divide two cells and if the number is negative display is as zero 2
change all below or equal to an input number 4
Number entries are automatically divided by 100 - Excel 2003 1
Divide numbers and distribute evenly. 0
All number inputs are divided by 100 ? 2
How to divide numbers in Excel? 0
my excel spread printed the cell numbers and letters/what's wrong 1
numbers in cells are automatically divided by 100. Not a format s. 1

Back
Top