Can you format a whole column of numbers to round?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a spreadsheet at work with a column of currency numbers. I would
like to set up a function so that all the numbers in that column round to the
nearest dollar. I have only been able to use the fx to round each individual
cell separately. Is there a way to set it up so that the entire column will
round?
 
It's normal for excel to round numbers to the nearest dollar as a display
format.
Any calculations will still take the original numbers including the
decimals.

Select the whole column by clicking onto the letter above the column .
Go to <>format <>cells<>number<>decimal places : 0

If you want to calculate everything with rounded values only then you need
to use the formula
=round(A1,0) for instance next to the original values.
You can copy this down using the right hand bottom corner of the cell.
<>when your mouse pointer changes to a "+" left click hold and drag down.
 
the function you would use is
=dollar(a1,0)
whereas a1 would be the top cell in the column. Then you copy a1,
highlight all the way to the last cell that you have data in- and
edit-fill down.

that should help you!
 
Select the whole column by clicking onto the letter above the column .
Go to <>format <>cells<>number<>decimal places : 0
Click to expand...

There is also a "precision as displayed" option in menu Tools >Options that
goes well with this formatting. Use it with great care, it will actually
add/remove cents to your numbers.

HTH. Best wishes Harald
 
Back
Top