How to apply significant figures in excel

Written by lyan uaha
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel 2010 can be configured to apply predefined significant figures or decimal places to cells in the Excel spreadsheet. You can apply significant figures to a single cell, group of cells or to the entire Excel document. Predefining the significant figures creates a rule in Excel that is applied to any number that you enter into the cell for which the rule was set.

Skill level:
Moderately Easy


  1. 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. 2

    Click the "Start" button on the taskbar, point to "All Programs," and then click "Microsoft Excel 2010."

  3. 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. 4

    Right-click in one of the selected cells and then click "Format Cells."

  5. 5

    Click the "Number" tab on the Format Cells dialogue box that opens.

  6. 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."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.