Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compare two cells for the same numbers | Excel Worksheet Functions | |||
Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
how to find duplicate cells in large array of numbers | Excel Worksheet Functions | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) |