Fix Numeric Values With INT & FIXED Functions In Excel 2010


Dealing with different data types in spreadsheet could be very hectic to get by. With simple functions provided by Excel 2010, you can ensure data consistency by applying different conditions over the values. Through INT and FIXED functions we can show the decimal values in any desired place, eventually giving your spreadsheet a nice & tidy look.

Launch Excel 2010 spreadsheet on which you want to apply basic numeric functions. For instance, we have included a spreadsheet containing fields; S.No and Values.


Now we will be applying different functions over the Values field, we will be rounding off the data values and show them in Integer and Decimal Fix field. First we start off with creating labels, as shown in the screenshot below.

table 2

Now in the first row of Integer field, we will be writing simple INT function to show integers in Values field without any decimals.

The syntax of the this function is;


The single argument which is required here is number, you can also put in any numeric value directly to find out the integer, but first we will be putting location of cell where value is residing.

We will write this function as;


The B2 is the location of  cell which would pass as an argument. It will yield value but without any decimals, as show in the screenshot below.


Now drag the plus sign at the end of the cell towards the end of the column to apply it over. As you can see in the table below that all the corresponding values have now been changed into Integer values, by removing the decimal values.


If you want to show data consistency by defining decimal places to be taken, then FIXED function would help. The basic syntax of Fixed function is;

=FIXED(number, [decimals], [no commas])

The first argument Number is any number that refers to value inserted directly or location of cell, the second argument in the function refers to how many decimal places you want to be taken by the output value, and [no commas] refers to two options TRUE or FALSE, TRUE would mean that commas will not be inserted and conversely FALSE mean that we need commas to be shown in the value.

We will write this function as;


As B2 is the location of the cell, the next argument 1 refers to single decimal place to be taken and TRUE referring to that we don’t need commas to be inserted. It will yield values like shown in the screenshot below.

fixed 1

Now for changing values which emulates accounting format, just change the last argument of the FIXED function to FALSE, then it would show commas in the value with 1 decimal place.

false 1

If you want to use these function by putting direct values then you need to enter the value in argument for which you want to show INT or FIXED value, as shown in the screenshots below;


integer value 1


fixed 2

You can also check out previously reviewed Excel function; DCOUNT, ISTEXT, ISNUMBER, Logical Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.