When I used to entre a number in my spread sheets as 120 it would read 120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now 1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please
--
Ian D Anderson

Tools - Options...
Choose the Edit tab and clear the *Fixed Decimal* option


Steve


On Sat, 28 Oct 2006 09:17:02 +0100, Andy
wrote:

When I used to entre a number in my spread sheets as 120 it would read
120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now
1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please

Andy

ToolsOptionsEdit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 01:17:02 -0700, Andy wrote:

When I used to entre a number in my spread sheets as 120 it would read 120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now 1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please

Just asking...
Did you see my reply
I ask because I want to check that my new server is propagating correctly.
It's not the first time that I've seen posts several hours after mine that
have *exactly* the same answer
hate to think my posts get through and are missed :)

Steve

On Sat, 28 Oct 2006 18:31:56 +0100, Gord Dibben <gorddibbATshawDOTca
wrote:

Andy

ToolsOptionsEdit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 01:17:02 -0700, Andy
wrote:

When I used to entre a number in my spread sheets as 120 it would read
120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now
1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please

Hi steve,

Yes thanks,

I was out and off line for about 18 hours. Many thanks for the tip! I do
still have another problem which I'll post later once typed.

Thanks Steve.
--
Ian D Anderson


"SteveW" wrote:

Just asking...
Did you see my reply
I ask because I want to check that my new server is propagating correctly.
It's not the first time that I've seen posts several hours after mine that
have *exactly* the same answer
hate to think my posts get through and are missed :)

Steve

On Sat, 28 Oct 2006 18:31:56 +0100, Gord Dibben <gorddibbATshawDOTca
wrote:

Andy

ToolsOptionsEdit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 01:17:02 -0700, Andy
wrote:

When I used to entre a number in my spread sheets as 120 it would read
120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now
1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please

Many thanks for your reply!
--
Ian D Anderson


"Gord Dibben" wrote:

Andy

ToolsOptionsEdit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 01:17:02 -0700, Andy wrote:

When I used to entre a number in my spread sheets as 120 it would read 120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now 1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please