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?

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?

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