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.

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.

Tools>Options>Edit.

Uncheck "fixed decimal places".


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 20:14:01 -0700, Prospector
<[email protected]> 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.

"RickM" <[email protected]> wrote in message
news:[email protected]...

> 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