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

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.

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

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.

RickM
Prospector wrote:
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.

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

ToolsOptionsEdit.

Uncheck "fixed decimal places".


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 20:14:01 -0700, Prospector
wrote:

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.

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

"RickM" wrote in message
oups.com...

Prospector wrote:
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.

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.
--
David Biddulph