LIMITING CELLS TO 2 DECIMAL PLACES IN EXCEL

[cvrjcu]

I have a small issue with an excel list that I am pulling information
from. Its a basic price list pulled from another companys list. The
problem is the company that the price originate from use an equasion
from another list to derive the actual totals. this means that numbers
can be up to 5 decimal places long. I need to know how to be able to
reduce absolutely, the entire column of numbers to 2 decimal places.
Not so that it just looks like 2 (as in making it a currency) but
actually rounding the real numbers to 2 dec places. Is there a simple
way to do this or is it more involved?

 

[Anne Troy]

=ROUND(a1,2)
That will round to the nearest 2 decimal places.
After you use this formula, you'll probably want to copy the results, keep
your selection in place, then hit Edit-->Paste special-->Values.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

 

[cvrjcu]

thanks for the fast reply Anne, however I cant seem to get that
working. Can you explain how I would get an entire column to do that?
Im a bit of a newb to excel functions.

 

[cvrjcu]

thanks for the fast reply Anne, however I cant seem to get that
working. Can you explain how I would get an entire column to do that?
Im a bit of a newb to excel functions.

 

[Chip Pearson]

In a column adjacent to your data, enter the formula

=ROUND(A1,2)

where A1 is the first data cell. Then, copy that formula down as
far as you need to go. To replace the original data, copy the
cells with the formulas, go to the Edit menu, choose Paste
Special, and choose the Values option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com