Cells dropping last to numbers

[dickhob]

All of the sudden when I enter a number like 3500 I get 35 in the cell. If I enter 12345 I get 124. The cells are formatted as GENERAL. Changing to numeric format (zero decimals) produces the same result. To retain the last two numbers, I must enter the decimal point at the end of the number.

I assume I've set something somewhere, but don't know where to look. Any ideas?

Thanks
****

[Niek Otten]

Tools>Options>Edit, uncheck Fixed decimal

--
Kind regards,

Niek Otten

"dickhob" <[email protected]> wrote in
message news:[email protected]...
>
> All of the sudden when I enter a number like 3500 I get 35 in the cell.
> If I enter 12345 I get 124. The cells are formatted as GENERAL.
> Changing to numeric format (zero decimals) produces the same result.
> To retain the last two numbers, I must enter the decimal point at the
> end of the number.
>
> I assume I've set something somewhere, but don't know where to look.
> Any ideas?
>
> Thanks
> ****
>
>
> --
> dickhob
> ------------------------------------------------------------------------
> dickhob's Profile:
> http://www.excelforum.com/member.php...o&userid=25277
> View this thread: http://www.excelforum.com/showthread...hreadid=500355
>