Whole Number Display in Excel Cells
Posted on 2006-11-30
I want to be able to type in a 4 + digit number without excel automatically assigning a decimal point for 2 places. I can only get 4 digits, for example, if I end the series of numbers with a manual decimal point. I have reloaced Microsoft Office completely, and excel still does this. For example, I can type in the number 1121 in Column A, and it appears when I tab out of it as 11.21. I can increase the decimals and it will appear as 11.210, 11.2100, 11.21000, etc. I can decrease the decimals and it will round off to 11. How can I fix this?