Remember Me?

#1
January 12th 05, 08:27 AM
 HÃ¸jrup Posts: n/a
How do I ROUND() round off decimals of a column dataset?

After importing data with four decimals into my Excel worksheet, I want to
round off all data to one decimal. It is rather cumbersome to round each
datapoint one by one. Is there a quicker way?

#2
January 12th 05, 08:41 AM
 Max Posts: n/a

Try on a spare copy

Assuming your data is in col A, A1 down

Put in B1: =ROUND(A1,1)
Copy down

Select col B

Do a copy paste special values ok
over col A (overwrite col A)

Delete col B

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Højrup" wrote in message
...
After importing data with four decimals into my Excel worksheet, I want to
round off all data to one decimal. It is rather cumbersome to round each
datapoint one by one. Is there a quicker way?

#3
January 12th 05, 10:50 AM
 Posts: n/a

-----Original Message-----
After importing data with four decimals into my Excel

worksheet, I want to
round off all data to one decimal. It is rather

cumbersome to round each
datapoint one by one. Is there a quicker way?
.
Highlight all the columns with the data in them. Then

format to 2 decimal places in one go.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post bob Excel Worksheet Functions 6 February 29th 08 07:11 PM jenniss Excel Discussion (Misc queries) 5 January 6th 05 08:18 PM prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM Richard Excel Worksheet Functions 1 November 16th 04 02:39 PM TylerMaricich Excel Worksheet Functions 6 November 8th 04 07:27 AM

All times are GMT +1. The time now is 02:55 PM.