Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was able to
enter integers into a column of cells, and having formatted the cells as
numbers having no decimal place have them show as integers and behave as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular that
the same spreadsheet run on another computer behaves the way it was
originally designed to - i.e, when I enter 1 I get 1. The problem is
not present when I run Excel in safe mode or when I run Windows XP in
safe mode, but it is very inconvenient to run Excel in safe mode and I
shouldn't have to anyway. I have checked for add-ons for Excel but they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice Calc
as an Excel program, but I'd like to be able to run it under Excel.

Can anyone help please or point me to a document in the Microsoft labyrinth?

--
Regards, Alex

Hi Alex

ToolsOptionsEditUncheck Fixed Decimal places

--
Regards

Roger Govier


"Alex Bell" wrote in message
...
Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was able
to enter integers into a column of cells, and having formatted the
cells as numbers having no decimal place have them show as integers
and behave as integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular
that the same spreadsheet run on another computer behaves the way it
was originally designed to - i.e, when I enter 1 I get 1. The problem
is not present when I run Excel in safe mode or when I run Windows XP
in safe mode, but it is very inconvenient to run Excel in safe mode
and I shouldn't have to anyway. I have checked for add-ons for Excel
but they there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice
Calc as an Excel program, but I'd like to be able to run it under
Excel.

Can anyone help please or point me to a document in the Microsoft
labyrinth?

--
Regards, Alex

Alex Bell wrote:
Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was able to
enter integers into a column of cells, and having formatted the cells as
numbers having no decimal place have them show as integers and behave as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular that
the same spreadsheet run on another computer behaves the way it was
originally designed to - i.e, when I enter 1 I get 1. The problem is
not present when I run Excel in safe mode or when I run Windows XP in
safe mode, but it is very inconvenient to run Excel in safe mode and I
shouldn't have to anyway. I have checked for add-ons for Excel but they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice Calc
as an Excel program, but I'd like to be able to run it under Excel.

Can anyone help please or point me to a document in the Microsoft labyrinth?

--
Regards, Alex

Hi Alex,

Check this...

Tools|Options|Edit|Fixed Decimal Places should NOT be ticked.

Ken Johnson

Ken Johnson wrote:
Alex Bell wrote:
Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was able to
enter integers into a column of cells, and having formatted the cells as
numbers having no decimal place have them show as integers and behave as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular that
the same spreadsheet run on another computer behaves the way it was
originally designed to - i.e, when I enter 1 I get 1. The problem is
not present when I run Excel in safe mode or when I run Windows XP in
safe mode, but it is very inconvenient to run Excel in safe mode and I
shouldn't have to anyway. I have checked for add-ons for Excel but they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice Calc
as an Excel program, but I'd like to be able to run it under Excel.

Can anyone help please or point me to a document in the Microsoft labyrinth?

--
Regards, Alex

Hi Alex,

Check this...

Tools|Options|Edit|Fixed Decimal Places should NOT be ticked.

Ken Johnson


Many thanks to you both. It's so simple if one knows what one is doing.
Any ideas why it suddenly changed? I seem to remember that I upgraded
around the same time.

--
Regards, Alex

Hi Alex

You're very welcome. Thanks for the feedback.
As to why it happened, I'm not sure.
Very Happy New Year to you.


--
Regards

Roger Govier


"Alex Bell" wrote in message
...
Ken Johnson wrote:
Alex Bell wrote:
Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was
able to
enter integers into a column of cells, and having formatted the
cells as
numbers having no decimal place have them show as integers and
behave as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as
0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular
that
the same spreadsheet run on another computer behaves the way it was
originally designed to - i.e, when I enter 1 I get 1. The problem
is
not present when I run Excel in safe mode or when I run Windows XP
in
safe mode, but it is very inconvenient to run Excel in safe mode and
I
shouldn't have to anyway. I have checked for add-ons for Excel but
they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice
Calc
as an Excel program, but I'd like to be able to run it under Excel.

Can anyone help please or point me to a document in the Microsoft
labyrinth?

--
Regards, Alex

Hi Alex,

Check this...

Tools|Options|Edit|Fixed Decimal Places should NOT be ticked.

Ken Johnson


Many thanks to you both. It's so simple if one knows what one is
doing. Any ideas why it suddenly changed? I seem to remember that I
upgraded around the same time.

--
Regards, Alex

As to WHY and/or HOW it happened:
This option (fixed decimal), *as well as* the (manual - auto) calculate
option are determined per session, by the saved option of the *first* file
opened in that session.

See if this old post explains it to you:

http://tinyurl.com/yj22zq

Don't forget, in this context, "calc" and "fixed decimal" are
interchangeable.
--
HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Alex Bell" wrote in message
...
Ken Johnson wrote:
Alex Bell wrote:
Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was able
to
enter integers into a column of cells, and having formatted the cells
as
numbers having no decimal place have them show as integers and behave
as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular that
the same spreadsheet run on another computer behaves the way it was
originally designed to - i.e, when I enter 1 I get 1. The problem is
not present when I run Excel in safe mode or when I run Windows XP in
safe mode, but it is very inconvenient to run Excel in safe mode and I
shouldn't have to anyway. I have checked for add-ons for Excel but
they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice
Calc
as an Excel program, but I'd like to be able to run it under Excel.

Can anyone help please or point me to a document in the Microsoft
labyrinth?

--
Regards, Alex

Hi Alex,

Check this...

Tools|Options|Edit|Fixed Decimal Places should NOT be ticked.

Ken Johnson


Many thanks to you both. It's so simple if one knows what one is doing.
Any ideas why it suddenly changed? I seem to remember that I upgraded
around the same time.

--
Regards, Alex

Hi RD
Thanks for that info.
I knew it applied to calculation mode, but not that it also applied to
fixed decimal.
The first of many new things to be learned in 2007 - I hope!!!

--
Regards

Roger Govier


"Ragdyer" wrote in message
...
As to WHY and/or HOW it happened:
This option (fixed decimal), *as well as* the (manual - auto)
calculate
option are determined per session, by the saved option of the *first*
file
opened in that session.

See if this old post explains it to you:

http://tinyurl.com/yj22zq

Don't forget, in this context, "calc" and "fixed decimal" are
interchangeable.
--
HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Alex Bell" wrote in message
...
Ken Johnson wrote:
Alex Bell wrote:
Forgive me if this is not the correct group for this problem; if
it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was
able
to
enter integers into a column of cells, and having formatted the
cells
as
numbers having no decimal place have them show as integers and
behave
as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows
as 0
if I format the cell as an integer but acts like a 0.01 in
formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular
that
the same spreadsheet run on another computer behaves the way it
was
originally designed to - i.e, when I enter 1 I get 1. The problem
is
not present when I run Excel in safe mode or when I run Windows XP
in
safe mode, but it is very inconvenient to run Excel in safe mode
and I
shouldn't have to anyway. I have checked for add-ons for Excel
but
they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under
OpenOffice
Calc
as an Excel program, but I'd like to be able to run it under
Excel.

Can anyone help please or point me to a document in the Microsoft
labyrinth?

--
Regards, Alex

Hi Alex,

Check this...

Tools|Options|Edit|Fixed Decimal Places should NOT be ticked.

Ken Johnson


Many thanks to you both. It's so simple if one knows what one is
doing.
Any ideas why it suddenly changed? I seem to remember that I
upgraded
around the same time.

--
Regards, Alex

Speaking of 2007 ... Does anyone know if this stupid "feature" is *STILL* a
"feature" in the 2007 version ? ! ? ! ?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roger Govier" wrote in message
...
Hi RD
Thanks for that info.
I knew it applied to calculation mode, but not that it also applied to
fixed decimal.
The first of many new things to be learned in 2007 - I hope!!!

--
Regards

Roger Govier


"Ragdyer" wrote in message
...
As to WHY and/or HOW it happened:
This option (fixed decimal), *as well as* the (manual - auto)
calculate
option are determined per session, by the saved option of the *first*
file
opened in that session.

See if this old post explains it to you:

http://tinyurl.com/yj22zq

Don't forget, in this context, "calc" and "fixed decimal" are
interchangeable.
--
HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Alex Bell" wrote in message
...
Ken Johnson wrote:
Alex Bell wrote:
Forgive me if this is not the correct group for this problem; if
it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was
able
to
enter integers into a column of cells, and having formatted the
cells
as
numbers having no decimal place have them show as integers and
behave
as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows
as 0
if I format the cell as an integer but acts like a 0.01 in
formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular
that
the same spreadsheet run on another computer behaves the way it
was
originally designed to - i.e, when I enter 1 I get 1. The problem
is
not present when I run Excel in safe mode or when I run Windows XP
in
safe mode, but it is very inconvenient to run Excel in safe mode
and I
shouldn't have to anyway. I have checked for add-ons for Excel
but
they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under
OpenOffice
Calc
as an Excel program, but I'd like to be able to run it under
Excel.

Can anyone help please or point me to a document in the Microsoft
labyrinth?

--
Regards, Alex

Hi Alex,

Check this...

Tools|Options|Edit|Fixed Decimal Places should NOT be ticked.

Ken Johnson


Many thanks to you both. It's so simple if one knows what one is
doing.
Any ideas why it suddenly changed? I seem to remember that I
upgraded
around the same time.

--
Regards, Alex

Ragdyer wrote:
As to WHY and/or HOW it happened:
This option (fixed decimal), *as well as* the (manual - auto) calculate
option are determined per session, by the saved option of the *first* file
opened in that session.

See if this old post explains it to you:

http://tinyurl.com/yj22zq

Don't forget, in this context, "calc" and "fixed decimal" are
interchangeable.

Thanks for your help, but I'm afraid I'm still puzzled. I certainly do
not remember doing anything with the Fixed Decimal places option when I
designed the spreadsheet 4-5 years ago, nor at any time since then. In
fact I didn't even know of this option's existence. That is, I'm as
certain as I can be that I didn't change anything (apart from upgrading)
before this problem suddenly appeared.

When I went to try the fix Ken and Roger gave me I tried the fix on the
spreadsheet which has been giving me grief and on a new spreadsheet, and
of course it worked. But I did not save the spreadsheets. A moment ago
I started a new dummy spreadsheet and the problem is still fixed.

And I can't see how the explanation Ragdyer gives explains why the same
spreadsheet works as expected on one computer and not on another.

--
Regards, Alex

PS Is there a convention about top posting or bottom posting in this
newsgroup? I'm used to bottom posting, but am happy to follow the
convention.

Hi Alex

If the first workbook opened on computer A did not have Fixed decimals
set, then the file would work fine.
If the first workbook opened on computer B had Fixed decimals set, then
that would be the default mode and the file would not work.

Remember, the first workbook opened could be the hidden Personal.xls and
the default Book.xlt.
If these are different on the 2 computers, this could explain what you
are seeing.

--
Regards

Roger Govier


"Alex Bell" wrote in message
...
Ragdyer wrote:
As to WHY and/or HOW it happened:
This option (fixed decimal), *as well as* the (manual - auto)
calculate
option are determined per session, by the saved option of the *first*
file
opened in that session.

See if this old post explains it to you:

http://tinyurl.com/yj22zq

Don't forget, in this context, "calc" and "fixed decimal" are
interchangeable.

Thanks for your help, but I'm afraid I'm still puzzled. I certainly
do not remember doing anything with the Fixed Decimal places option
when I designed the spreadsheet 4-5 years ago, nor at any time since
then. In fact I didn't even know of this option's existence. That
is, I'm as certain as I can be that I didn't change anything (apart
from upgrading) before this problem suddenly appeared.

When I went to try the fix Ken and Roger gave me I tried the fix on
the spreadsheet which has been giving me grief and on a new
spreadsheet, and of course it worked. But I did not save the
spreadsheets. A moment ago I started a new dummy spreadsheet and the
problem is still fixed.

And I can't see how the explanation Ragdyer gives explains why the
same spreadsheet works as expected on one computer and not on another.

--
Regards, Alex

PS Is there a convention about top posting or bottom posting in this
newsgroup? I'm used to bottom posting, but am happy to follow the
convention.