Rounding down Figures in a cell

B

Biff

Hi Marcus!

Use a helper column with this formula:

=INT(A1)

Biff
-----Original Message-----
Hi

Does anyone know how to round down a figure in a cell.
Click to expand...
For example, in cell A1 I enter 654.99, I want it to round
down and only show 654. I've tried formatting the cell
with ### etc, but it rounds up - not down.
 
Top