How to Drop Decimal Places Without Rounding in Microsoft Excel

Written by david sarokin Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Drop Decimal Places Without Rounding in Microsoft Excel
You can use Excel spreadsheet software to create tables of text and numbers. (Jupiterimages/Photos.com/Getty Images)

Microsoft Excel spreadsheet software offers users a large collection of tools for manipulating sets of numbers and text. The mathematical functions in Excel allow you to automate the process of erasing the decimal portion of a number and leaving just the whole number digits to the left of the decimal point. Once you know the right function to use, the procedure is straightforward.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open a blank worksheet in Excel and type a decimal number in the A1 cell. Use this worksheet for practice before applying the procedure to an actual file.

  2. 2

    Type the "integer function" into cell B1 as follows: f=INT(A1). The integer function lops off the decimal value of a number leaving only the whole number digits to the left of the decimal place. The formula in cell B1 instructs Excel to find the integer value of cell A1 and place that value in cell B1.

  3. 3

    Click any other cell in the spreadsheet to exit from cell B1. The cell will now display the integer value of the number in A1. For example, if A1 contains the number 10.54, cell B1 will display the number 10.

  4. 4

    Type another decimal number in cell A5.

  5. 5

    Copy cell B1 and paste it into cell B5 to put a copy of the integer formula in B5. Click out of the cell to show the integer value of A5 in B5. As you copy and paste the integer formula, Excel automatically adjusts the parameters to find the integer value of A5 rather than A1.

  6. 6

    Use the integer function in an actual spreadsheet to drop the decimal values of a number and leave only the whole number.

Tips and warnings

  • The integer function is available in Excel 2010 and earlier versions of the program.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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