How do I ROUND() round off decimals of a column dataset?

[Højrup]

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?

[Max]

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 <at>yahoo<dot>com
----
"Højrup" <[email protected]> wrote in message
news:[email protected]...
> 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.