Tuesday, October 25, 2011

How to Apply Significant Figures in Excel


1. Double-click the Microsoft Excel 2010 file icon to which you want to apply significant figures to open it. Alternatively, to open a new Excel document, skip to the next step, else go to step 3.
2. Click the 'Start' button on the taskbar, point to 'All Programs,' and then click 'Microsoft Excel 2010.'
3. Press and hold the 'Ctrl' key on your keyboard and then one-by-one click in the cells to which you want to apply significant figures. This will select the cells you click. To select all the cells in the document, press 'Ctrl A'.
4. Right-click in one of the selected cells and then click 'Format Cells.'
5. Click the 'Number' tab on the Format Cells dialog box that opens.
6. Click 'Number' below Category, type the number of significant figures you want in the 'Decimal places' box (for example 6), and then click 'OK.'

Blogger news