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