MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format cell to display trunated decimal W/O rounding

Posted by Oscar Trevino on March 16, 2000 11:53 AM

How do I write a formula that will SUM a column of
numbers where each cell in said column contains
numbers that go out four decimal places, but that will
display the UNROUNDED result to only TWO decimal

ie: 56.4167 displayed total = 56.41 NOT 56.42

Posted by judi on March 16, 2000 1:27 PM

The function you need is:


A sample formula would be:


Posted by Oscar on March 20, 2000 9:35 AM

Thanks, that worked!