Excel 97 SR-1
Excel 97 SR-1
(OP)
I have just started using a new Sony laptop (win2K & Xl 97 SR-1) but the numerical data entry is alwways divided by 100
eg type 123 and get 1.23 - this does not happen in a formula entry eg =10*10 and it displays 100
Anyone got any ideas?
eg type 123 and get 1.23 - this does not happen in a formula entry eg =10*10 and it displays 100
Anyone got any ideas?





RE: Excel 97 SR-1
select the menu item /Tools/Options, then select the Edit Tab. See if the box for fixed decimal places is checked and if 2 is the number in the box there. Uncheck the fixed decimal box and try it then.
Regards,
chichuck
RE: Excel 97 SR-1