If they are not the result of formulas, and you are happy to lose the detail,
then assuming your data is in say A1:A100, in B1 put =ROUND(A1,2) and copy down
to B100. Now copy B1:B100 and then select A1 and do Edit / Paste Special /
Values. Then just delete B1:B100.

If you don't want to lose the detail, use Col B as the source for your
subtotalling.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"projectside" wrote in message
...

i actually need the numbers to either be rounded up or truncated to 2
decimal places only so then I can use those numbers in another columns
for calculation

197.8938 (i need it to be 197.89)
56.34432 (to be 56.34)
29.3193 (to be 29.32)
78.89345 (to be 78.89)

the rounded numbers will then be used in a calculation to calculate sub
total.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003