Can you format a whole column of numbers to round?
 

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.

"dawn" wrote in message
...
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?

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!


--
rae820
------------------------------------------------------------------------
rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=377542

"Bill Kuunders" skrev i melding
...

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

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

thanks!

"rae820" wrote:


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!


--
rae820
------------------------------------------------------------------------
rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=377542