rounding up
 

I have a question. I have an excel files with numbers in one colum
(multiple rows). How do I round the numbers up in each row withou
doing it one by one?

Please hel

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

rounding up
 

How do you want to round them up - nearest 1, 100, 1000. Does the rounding need
to be an actual rounding or just look rounded? Is the data hardwired data, or
is it the result of formulas??

--
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 have a question. I have an excel files with numbers in one column
(multiple rows). How do I round the numbers up in each row without
doing it one by one?

Please help


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

rounding up
 

columns(5).numberformat = "#,###"

will give a rounded appearance - not sure what you actually want.



--
Regards,
Tom Ogilvy

"projectside" wrote in message
...

I have a question. I have an excel files with numbers in one column
(multiple rows). How do I round the numbers up in each row without
doing it one by one?

Please help


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

rounding up
 

2 decimal places.. the data is an average price that looks like this:

197.8938 (i need it to be 197.89)
56.34432 (to be 56.34)
29.3193
78.89345
etc...

something like that...they are all in one column with multiple rows..

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

rounding up
 

i actually need the numbers to either be rounded up or truncated to
decimal places only so then I can use those numbers in another column
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 su
total

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

rounding up
 

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

rounding up
 

3 refers to column C (3rd column) adjust to match your column

set rng = Range(Cells(1,3),Cells(rows.count,3).End(xlup))
for each cell in rng
cell.Value = Application.Round(cell.value,2)
Next

--
Regards,
Tom Ogilvy

"projectside" wrote in message
...

2 decimal places.. the data is an average price that looks like this:

197.8938 (i need it to be 197.89)
56.34432 (to be 56.34)
29.3193
78.89345
etc...

something like that...they are all in one column with multiple rows...


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

rounding up
 

Why not just insert a new colum with =roundup(a1,0). then
copy paste specialValues. then delete original colum.

Hit the record new macro button while you do this the
first time and you will havwe all the syntax for future
applications.

Pete

-----Original Message-----

I have a question. I have an excel files with numbers in
one column
(multiple rows). How do I round the numbers up in each
row without
doing it one by one?

Please help


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

.