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

J

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
 
N

Norman Jones

Hi Jeroen,

Try:

Tools | Options | Calculation | uncheck Fixed Decimal Places
 
Top