[SOLVED] Can you format a whole column of numbers to round?

[dawn]

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?

[rae820]

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!

[Bill Kuunders]

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" <[email protected]> wrote in message
news:[email protected]...
>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?

[Harald Staff]

"Bill Kuunders" <[email protected]> skrev i melding
news:%[email protected]...

> 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

[dawn]

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
>
>