I have a list of numbers in column A that go to several decimal places (e.g. A1 is 27.34
). Is there a way to fill column B with the same values as column A, but rounding to the nearest integer?



Try this formula in B1



excel has a floor() funcion floor() The syntax for the FLOOR function is: FLOOR( number, significance ) number is the number that you wish to round down. significance is the multiple of significance that you wish to round a number to. 


Another way, without using functions, is to use the Decrease Decimal button from the Number group in the Home tab. 


For positive numbers,



Try 


Use the TRUNC function. i.e. B1 =TRUNC(A1) 


Click cell B1 , type 


I would use the RoundDown function, as it is designed specifically for what you are asking. It takes two arguments, the first being the number [or cell reference] you want to round down, the second being the amount of decimals it should have. Examples: =ROUNDDOWN(3.1456,0) becomes 3 =ROUNDDOWN(3.1456,1) becomes 3.1 =ROUNDDOWN(3.1456,2) becomes 3.14 =ROUNDDOWN(3.1456,3) becomes 3.145 =ROUNDDOWN(3.1456,4) becomes 3.1456 

