<div>
Hi proactiveit,<br />
In the Tools...Options...Edit menu item, you have the ability to fix the number of decimal places. If you uncheck the option for Fixed decimal places, Excel will let you type a four digit number and let it become 1121.<br />
<br />
Hoping to be helpful,<br />
<br />
Brad
</div>


Hi proactiveit,
In the Tools...Options...Edit menu item, you have the ability to fix the number of decimal places. If you uncheck the option for Fixed decimal places, Excel will let you type a four digit number and let it become 1121.

Hoping to be helpful,

Brad

<div>
<div class="content wysiwyg-content">
I want to be able to type in a 4 + digit number without excel automatically assigning a decimal point for 2 places. &nbsp;I can only get 4 digits, for example, if I end the series of numbers with a manual decimal point. &nbsp;I have reloaced Microsoft Office completely, and excel still does this. &nbsp;For example, I can type in the number 1121 in Column A, and it appears when I tab out of it as 11.21. &nbsp;I can increase the decimals and it will appear as 11.210, 11.2100, 11.21000, etc. &nbsp;I can decrease the decimals and it will round off to 11. &nbsp;How can I fix this?
</div>
</div>


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?

Whole Number Display in Excel Cells

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.