Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
"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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do a conditional format for numbers | Excel Worksheet Functions | |||
Is there a cell format for HEX numbers? | Excel Discussion (Misc queries) | |||
Column format when merging Excel data to Word labels | Excel Discussion (Misc queries) | |||
add only positive numbers and avg in a column | Excel Worksheet Functions | |||
Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) |