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

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.

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

Tools Options un-check Fixed Decimal

Vaya con Dios
Chuck, CABGx3


"Paul KdN" <Paul wrote in message
...
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.

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

"CLR" wrote:

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

Tools Options un-check Fixed Decimal

Vaya con Dios
Chuck, CABGx3


"Paul KdN" <Paul wrote in message
...
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.