Automatically insert a decimal point in entered numbers
Click the “File” tab
Excel options
Automatically insert decimal places
① Check [Automatically insert decimal point position] and set [Input unit]. (2) Click [OK].
Enter numerical data
Turn off Auto Insert Decimal Point in Entered Numbers
Related Excel Articles
How to insert a line break in a cell in Excel (Win/Mac)Excel – How to auto-save and back up Excel How to set/unlock a password for an Excel file Excel – How to display the Developer tab Excel – Delete recent items How to (hide)
