I'm having a problem with the Excel work sheets in general.
When I enter a WHOLE number and press enter it appears as a two digit decimam number example I enter 1 and it apperas as 0.01 is there a way to fix this
Solutions to the Problem Decimal defiance
Click the Office button in the top left corner and choose Excel Options.
Advanced from the list down the left and look for Automatically insert a decimal point.
It should the second option down in the top
Editing options section.
Uncheck this and click OK in the lower right.
To check for Windows updates
- Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
- In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
- If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
Another Safe way to Fix the Problem: Decimal defiance:
How to Fix Decimal defiance with SmartPCFixer?
1. You can Download Error Fixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: Action Center On My Computer Stopped Working About A Week Ago. It Won't Open.,"Atheros AR9485WB-EG Wireless Network Adaptor Is Experiencing Driver Or Hardware-related Problems" How Do I Fix This?,4 Questions On Restore Files And Recover System,Allowings One Person To Access A MS Access Database At A Time,Arrow Cursor On Desktop Screen,0 Is Showing As A Result Of Formula,Win 7 Backup And Restore Program Content Question,Windows 7 Will Only Start In Safe Mode!,Windows Was Unable To Create A Required Instillation Folder Error 0x80070005,Presentation Mode Is Always On When I Turn On My Computer. My Desktop Icons Are Gone And The Computer Seems To Run Slower.,Title Of Saved File,How Can I Change My E-mail From Windows Live Mail To Yahoo Mail? Whenever I Try And Send Something In Windows Mail It Tells Me It's The Wrong Server.,How To Merge/delete Networks In Windows 8/8.1 ? The Option Is Missing Here.,When I Use Hibernate Mode For More Than 2 Days I Can't Load Windows 7 Home Premium,Display Driver Has Stopped Working And Has Recovered Error
Read More: How to Resolve - Entering more than one record in Mail Merge?,How do you prevent empty text form fields from printing on a template? [Anwsered],Solution to Error: defragmentation doesn't work on vista,[Solution] I can't initiate video call and can't accept video call from others?,ms office 2010 stopped working [Anwsered],Pc does not meet security requirements when trying to connect the computer remotely,IE 11 options under Security -- Internet Zone is locked,matlab 2007 windows 7 incompatibility,Windows 7 compatibility not working,homegroup setup fails