How do your round down an entire column?
Create a column next to your money column
=ROUNDDOWN(A1,0)
A1 would be the 1st cell with your currency, then just copy the formula down
"skibum22" wrote:
I am trying to round down an entire column of currency with different
amounts. I can do it with one cell at a time but I need to do the entire
column. For example I want to take $15.75 to $15.00 and $14.34 to $14.00 and
so on all the way down the column.
|