Excel XP

Richardgford · Feb 6th 2003

I've just updated to Office XP from Office 97.
When I try to enter a number in Excel the result displayed in the cell has been divide by 100
eg if I enter 1001 the result shown is 10.01
I've checked everything I can think of in the default settings, the cell formats and the regional settings in the Control Panel but I can't find anything that is causing this annoying affect

XL-Dennis · Feb 6th 2003

Hi,

Propably You need to reset the fixed decimal.

Tools | Options | Tab Edit | untick the Fixed Decimal.

Kind regards,
Dennis

Excel XP

Participate now!

Share