MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chopping of intergers after decimal point

Posted by Keson Lim on January 28, 2002 10:35 PM

Hi All,

I have a formula which returns a value with decimal places. I want only the integers before the decimal place but I do not want the value to be rounded up. I have tried to format the cell to 'number' and specify number of decimal places = 0 but this will round up the integer.

Hope someone can help me out here...

Posted by Igor on January 28, 2002 11:33 PM

Hi, a simple way to fix this problem is to add another column beside the one with your numbers. Say, column "A" has your data, the formula in column "B" would be:


when you round the numbers in column B, it will adjust it so that it rounds it effectively to the integer instead of the first decimal place.

Hope it helps.


Posted by Keson on January 28, 2002 11:39 PM

Hi Igor,

Thanks alot, that was really helpful. It was such a simple yet brilliant step...

Posted by Aladin Akyurek on January 29, 2002 12:33 AM




will also do what you want.


Posted by mike sullivan on March 28, 2002 1:09 PM

Another solution would be to use the rounddown function =rounddown(cell,0; this will return a value with no decimals and will always be the interger part of the original cell.