'%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)
How to Stop Excel from Automatically Changing Numbers to 1 Percent
Question details
Users are experiencing an issue where standard numbers entered into cells are automatically reduced to one-hundredth of their value.
- Product
- Excel for Microsoft 365
- Device & OS
- Mac
- Scenario
- Typing standard numeric data or integers into a spreadsheet.
- Observed behavior
- Excel automatically converts entered numbers to 1% of their intended value (for example, typing 100 results in 1) because an automatic decimal or percentage setting is enabled.
Ensure you have saved your current workbook. Be aware that disabling this setting will only apply to future data entries and will not retroactively correct numbers that have already been converted.
Disable Automatic Decimal Insertion in Excel Preferences
Modifying Excel's editing preferences stops the application from automatically applying decimal places or dividing entered numbers by 100.
Excel has an application-level setting designed to speed up financial data entry by automatically adding decimal points. When accidentally enabled, it causes normal integers to appear as fractions or 1 percent of their original value.
Click on 'Excel' in the top Mac menu bar next to the Apple logo, then select 'Preferences' from the dropdown menu.
In the Preferences dialog box, locate and click on the 'Edit' icon under the Authoring section.
Find the checkbox labeled 'Display this number of decimal places' or 'Automatically insert a decimal point'. Uncheck this box to disable the automatic conversion.
Close the Preferences window. Return to your spreadsheet and manually re-enter the previously affected values to display them correctly.
Experience Hassle-Free Data Entry with WPS Office
If automated settings in Microsoft Excel for Mac are causing frustration and slowing down your workflow, consider switching to WPS Office. It provides a highly compatible spreadsheet editor that respects your manual data entry without unexpected automated decimal conversions.
- 1. Download WPS Office: Visit the official WPS website and download the installation package designed for your Mac operating system.
- 2. Install the Software: Open the downloaded file and follow the straightforward on-screen instructions to install WPS Office on your device.
- 3. Open Your Spreadsheet: Launch WPS Spreadsheet, open your existing workbook, and continue entering your numeric data without frustrating automated interruptions.
Frequently Asked Questions
How can I quickly fix the numbers that were already converted to 1 percent?
Type 100 in an empty cell and copy it. Select all the incorrectly converted numbers in your spreadsheet, right-click, choose 'Paste Special', select 'Multiply' under the Operation section, and click OK. This will instantly multiply the selected cells by 100, restoring their original values.
Does this automatic decimal setting apply to all Excel workbooks?
Yes, the automatic decimal insertion is an application-level preference in Excel. Once enabled or disabled in the Mac preferences menu, it universally affects all workbooks opened or created on that specific computer.
Why does Excel have an automatic decimal feature in the first place?
This feature is designed for accountants and users who need to enter large amounts of financial data or percentages rapidly. It allows them to type numbers continuously without manually typing the decimal key for every single entry, though it causes confusion for general use.
