'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Changing 400 to 4 (Automatic Decimal Issue)
Question details
Excel for Mac automatically inserts a decimal point into typed numbers, causing inputs like 400 to be converted to 4.
- Product
- Excel for Mac
- Device & OS
- macOS
- Scenario
- Typing numeric data into spreadsheet cells.
- Observed behavior
- When entering a whole number, the application automatically places a decimal point two places from the right, effectively dividing the entered number by 100.
Verify that your cells do not have custom formatting or formulas dividing inputs by 100, as this solution specifically addresses a global application preference issue.
Disable the Automatic Decimal Point Setting in Preferences
This is the most effective solution to stop Excel for Mac from automatically inserting decimal points into new numeric entries.
The automatic decimal point feature is designed to speed up financial data entry, but if it is enabled accidentally, it will alter standard whole numbers. Disabling this setting in your Mac Excel preferences will immediately restore normal data entry behavior.
Launch Microsoft Excel on your Mac. Navigate to the top menu bar, click on 'Excel', and select 'Preferences' from the dropdown menu.
In the Excel Preferences dialog box, locate the 'Authoring' section and click on the 'Edit' icon.
Look for the checkbox labeled 'Automatically insert a decimal point'. Click to uncheck this box, then close the Preferences window to save your changes.
Try WPS Office for Stable Spreadsheet Management on Mac
If you are frustrated by unexpected settings changes and formatting issues in Excel for Mac, consider switching to WPS Office. It provides a highly compatible, lightweight, and user-friendly alternative for all your spreadsheet tasks.
- 1. Download WPS Office: Visit the official WPS Office website and download the Mac installer for free.
- 2. Install on Your Mac: Open the downloaded file and drag the WPS Office icon to your Applications folder to complete the installation.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel files directly to continue working without annoying auto-formatting issues.
Frequently Asked Questions
Will disabling the automatic decimal point fix the numbers I already typed?
No, changing this preference only affects new data entered into your spreadsheet. Any numbers you previously entered that were changed (e.g., 400 to 4) will need to be manually corrected or multiplied by 100.
How can I quickly fix the existing incorrect numbers in my sheet?
Type 100 in an empty cell and copy it. Select all the cells containing the incorrect numbers, right-click, and choose 'Paste Special'. Select 'Multiply' under Operations and click OK to bulk-convert them back to whole numbers.
Why would someone want the automatic decimal point feature turned on?
Accountants and data entry clerks who type long lists of financial figures (like $4.00, $5.50) use this feature so they do not have to press the decimal key for every entry, saving time during repetitive typing.
Does this issue happen on the Windows version of Excel as well?
Yes, this feature exists in Excel for Windows too. It can be found by navigating to File > Options > Advanced, and then unchecking the 'Automatically insert a decimal point' box under Editing options.
