One way to try:

Select the column
Click Data Text to Columns Finish

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ronald" wrote in message
...
how to change data in worksheet in text without confirming each single
cell
with F2