Tuesday, May 24, 2011

How to Stop Rounding in Excel


1. Open the Excel workbook that currently uses rounded numbers. Click on the affected worksheet.
2. Highlight the cell(s) that hold the numbers. Do so by clicking a single cell, dragging the cursor across several cells, clicking a row number or a column letter.
3. Right-click on the highlighted cell(s). Select 'Format Cells' from the menu, which opens the Format Cells dialog box.
4. Select the 'Number' tab. Click 'Number' in the Category pane. Press the up arrow next to the Decimal Places box to increase the number of digits after the decimal, such as '5' or '7' places after the point.
5. Click the 'OK' button to save the changes to number-rounding.

Blogger news