How to stop rounding numbers in Excel?
When you type a number with decimal value like 433255.424256 or a number like 1.0 into a cell in Excel, by default, the number will be auto rounded to 433255.4243 or 1. But in general, you need the exact data, so now I tell how to stop rounding numbers in Excel.
Stop rounding numbers by formatting as text in Excel
Stop rounding numbers by formatting as text in Excel
If you want to keep the exact data you type in the cell, you can format the data range as text before you typing the data.
1. Select the range you are going to type the number data into, and right click to select Format Cells from the context menu. See screenshot:
2. Then in the Format Cells dialog, click Number tab, and select Text from the Category list. See screenshot:
3. Click OK. Then when you type number data into the range, the data will keep exact.
Relative Articles:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!