I recently transferred to a new PC, bringing with me Excel 97 SR-2 and
a clutch of long-serving worksheets. However, I'm having problems
entering numbers on these old sheets. In a column formatted "Number"
with 0 decimal places, I was accustomed to typing a five-digit mileage
figure. Now, when I press 'Return', the five-digit number is rounded
to a three-digit one (i.e. 20289 turns into 203) I notice that, in
the formula bar, a decimal point has been inserted.

Secondly, in columns formatted "Number" with 2 decimal places, that I
use for sums of money, I need to type numbers after the decimal point.
I can no longer type a whole number of pounds, press 'Return' and have
a decimal point and two zeroes added automatically. Instead, 25
becomes 0.25, not 25.00.

OS on the old machine was XP Home; on the new one it's XP Pro SP2.
Clearly I need to tweak something - what is it, please?

TIA,

--
Martyn Tindall
Leeds, England, United Kingdom

Martyn,

click on Tools | Options | Edit tab and unselect the Fixed Decimal
option about half-way down.

It would also pay you to have a look at all the other options on these
tabs to see if any are different to how you had them set on your other
machine.

Hope this helps.

Pete

On Jan 6, 10:04*pm, (Martyn
Tindall) wrote:
I recently transferred to a new PC, bringing with me Excel 97 SR-2 and
a clutch of long-serving worksheets. *However, I'm having problems
entering numbers on these old sheets. *In a column formatted "Number"
with 0 decimal places, I was accustomed to typing a five-digit mileage
figure. *Now, when I press 'Return', the five-digit number is rounded
to a three-digit one (i.e. 20289 turns into 203) *I notice that, in
the formula bar, a decimal point has been inserted.

Secondly, in columns formatted "Number" with 2 decimal places, that I
use for sums of money, I need to type numbers after the decimal point.
I can no longer type a whole number of pounds, press 'Return' and have
a decimal point and two zeroes added automatically. *Instead, 25
becomes 0.25, not 25.00.

OS on the old machine was XP Home; on the new one it's XP Pro SP2.
Clearly I need to tweak something - what is it, please?

TIA,

--
Martyn Tindall
Leeds, England, United Kingdom

On Tue, 6 Jan 2009 14:22:58 -0800 (PST), Pete_UK
wrote:

Martyn,

click on Tools | Options | Edit tab and unselect the Fixed Decimal
option about half-way down.

It would also pay you to have a look at all the other options on these
tabs to see if any are different to how you had them set on your other
machine.

Hope this helps.

Pete

Thanks, I'll try that...

Martyn


On Jan 6, 10:04=A0pm, (Martyn
Tindall) wrote:
I recently transferred to a new PC, bringing with me Excel 97 SR-2 and
a clutch of long-serving worksheets. =A0However, I'm having problems
entering numbers on these old sheets. =A0In a column formatted "Number"
with 0 decimal places, I was accustomed to typing a five-digit mileage
figure. =A0Now, when I press 'Return', the five-digit number is rounded
to a three-digit one (i.e. 20289 turns into 203) =A0I notice that, in
the formula bar, a decimal point has been inserted.

Secondly, in columns formatted "Number" with 2 decimal places, that I
use for sums of money, I need to type numbers after the decimal point.
I can no longer type a whole number of pounds, press 'Return' and have
a decimal point and two zeroes added automatically. =A0Instead, 25
becomes 0.25, not 25.00.

OS on the old machine was XP Home; on the new one it's XP Pro SP2.
Clearly I need to tweak something - what is it, please?

TIA,

--
Martyn Tindall
Leeds, England, United Kingdom



--
Martyn Tindall
Leeds, England, United Kingdom

On Tue, 6 Jan 2009 14:22:58 -0800 (PST), Pete_UK
wrote:

Martyn,

click on Tools | Options | Edit tab and unselect the Fixed Decimal
option about half-way down.

Thanks, that did the trick.

It would also pay you to have a look at all the other options on these
tabs to see if any are different to how you had them set on your other
machine.

All the other settings are the same. What irritates me is that I must
have had the wit to change the Fixed Decimal option for myself seven
years ago!!

Thanks again,
Martyn

Hope this helps.

Pete

On Jan 6, 10:04=A0pm, (Martyn
Tindall) wrote:
I recently transferred to a new PC, bringing with me Excel 97 SR-2 and
a clutch of long-serving worksheets. =A0However, I'm having problems
entering numbers on these old sheets. =A0In a column formatted "Number"
with 0 decimal places, I was accustomed to typing a five-digit mileage
figure. =A0Now, when I press 'Return', the five-digit number is rounded
to a three-digit one (i.e. 20289 turns into 203) =A0I notice that, in
the formula bar, a decimal point has been inserted.

Secondly, in columns formatted "Number" with 2 decimal places, that I
use for sums of money, I need to type numbers after the decimal point.
I can no longer type a whole number of pounds, press 'Return' and have
a decimal point and two zeroes added automatically. =A0Instead, 25
becomes 0.25, not 25.00.

OS on the old machine was XP Home; on the new one it's XP Pro SP2.
Clearly I need to tweak something - what is it, please?

TIA,

--
Martyn Tindall
Leeds, England, United Kingdom



--
Martyn Tindall
Leeds, England, United Kingdom