Forum Discussion
Gary517
Oct 04, 2023Copper Contributor
decimal points don't display on my recovered worksheet
Somebody hacked my desktop and cleared most of my files. I contacted HP as I have an HP desktop PC, and their tech spent 3.5 hours restoring what he could. I talked with Microsoft about the remaining...
Gary517
Oct 04, 2023Copper Contributor
I probably wasn't clear enough, EVERY Excel workbook has these issues: no decimal point, and the inability to simply enter a negative value using the - prefix. Thanks
NikolinoDE
Oct 04, 2023Gold Contributor
You are facing these issues across all your Excel workbooks, and it is not limited to a single file. In this case, it is possible that there might be a configuration issue or a global setting affecting Excel's behavior on your computer. Let us try a few additional steps to troubleshoot and resolve these issues:
- Excel Calculation Options:
- Sometimes, calculation options in Excel can affect the display of decimal points and number formatting. Ensure that your Excel is set to "Automatic" calculation mode:
- Open Excel.
- Go to the "File" tab.
- Click on "Options."
- In the Excel Options dialog box, go to the "Formulas" category.
- Under "Calculation options," select "Automatic."
- Click "OK" to save the changes.
- Reset Excel to Default Settings:
- If the issues persist, you can try resetting Excel's settings to their default values. Keep in mind that this will reset various Excel settings to their initial state, so you may need to reconfigure some preferences:
- Close Excel if it is open.
- Press the Windows key + R to open the Run dialog.
- Type excel /unregserver and press Enter.
- Type excel /regserver and press Enter.
- After running these commands, open Excel and check if the issues have been resolved.
- Repair Microsoft Office:
- If the problems persist after trying the above steps, you can try repairing your Microsoft Office installation:
- Close all Office applications.
- Go to "Control Panel" (you can search for it in the Start menu).
- Click on "Programs" or "Programs and Features."
- Locate Microsoft Office in the list of installed programs.
- Right-click on Microsoft Office and choose "Change" or "Repair."
- Follow the on-screen instructions to repair the installation.
- Update Microsoft Office:
- Ensure that your Microsoft Office suite is up to date. Sometimes, updating Office can resolve known issues:
- Open any Office application, such as Word or Excel.
- Go to the "File" tab.
- Click on "Account."
- Under "Product Information," click on "Update Options."
- Choose "Update Now."
- Allow Office to check for and install any available updates.
If these steps do not resolve the issues, it may be beneficial to reach out to your IT department for further assistance, as there could be specific system configurations or issues requiring deeper investigation. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.