software

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
Dick--
dickhob
------------------------------------------------------------------------
dickhob's Profile: www.excelforum.com/member.php...oamp;userid=25277
View this thread: www.excelforum.com/showthread...hreadid=500355Toolsgt;Optionsgt;Edit, uncheck Fixed decimal

--
Kind regards,

Niek Otten

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