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

P

Prospector

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.
 
R

RickM

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.
 
D

David Biddulph

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.
 
Top