Excel 97 numeral input (eg) 6 goes 0,06

[jeroen tiebout]

Hi everybody,

In one of our IT rooms (edu enviroment) we still use
Excel 97.
On one of the clients, when u input a numeral value in
any of the cells in a new document, the value is divided
by 100.
1 -> 0,01
60 -> 0,6
300 -> 3

cell formating says nothing special (identical to other
workstations without this problem)

I tried creating a template and place it in C:\Program
Files\Microsoft Office\Office\XLStrart and such, no
success.

Any ideas?
thx in advance,

Jeroen Tiebout
Sint-Niklaasinstituut
1070 Anderlecht - Belgium

 

[Frank Kabel]

Hi
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals'

 

[Norman Jones]

Hi Jeroen,

Try:

Tools | Options | Calculation | uncheck Fixed Decimal Places

 

[Jeroen Tiebout]

Solved indeed, thx Norman, thx Frank!

-----Original Message-----
Hi
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals'
.