Problem entering numbers

M

Martyn Tindall

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,
 
P

Pete_UK

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
 
M

Martyn Tindall

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
 
M

Martyn Tindall

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top