When I enter a number in an empty cel, de cel returns the value d.

[Paul KdN]

When I enter a number in an empty cel, de cel returns the value divided by 100.

so in een new worksheet as well in my saved xls files entering 900 returns 9
and entering 6 returns 0,06. Profile and cel format are standard.

This started after a crash.

 

[CLR]

Maybe try..........

Tools > Options > un-check Fixed Decimal

Vaya con Dios
Chuck, CABGx3

 

[Paul KdN]

Thanks, the problem was a check in automatic percentage input.