Friday, January 20, 2012

How to Stop Excel From Rounding Up or Down the Numbers to the Nearest Whole Number


1. Launch Microsoft Excel. If you have an existing file you wish to work with, click 'File' at the top of the window, and then click 'Open' to browse to that file.
2. Locate the cell(s) containing the values you want to prevent Excel from rounding. If there are multiple cells not in the same column or row, hold down the 'Ctrl' key as you click each cell with your mouse. If you want to adjust all of the files in a row or column, click the number to the left of the row or the letter at the top of the column to select the entire row or column.
3. Click the 'Home' tab at the top of the window.
4. Click 'Format' in the 'Cells' section of the ribbon at the top of the window, and then click 'Format Cells.'
5. Click the 'Number' tab at the top of the window.
6. Click 'General' under the list of options in the column at the left side of the window, and then click 'OK.'

Blogger news