Cells dropping last to numbers
 

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: http://www.excelforum.com/member.php...o&userid=25277
View this thread: http://www.excelforum.com/showthread...hreadid=500355

Cells dropping last to numbers
 

ToolsOptionsEdit, uncheck Fixed decimal

--
Kind regards,

Niek Otten

"dickhob" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=25277
View this thread: http://www.excelforum.com/showthread...hreadid=500355