1. Select your data and choose Data, Text to Columns from the menu.
2. At Step 1 choose Fixed width and click Next twice.
3. Click Advanced, choose ',' for Decimal separator and '.' for Thousands separator and click OK.
4. Click Finish
If you switch on the macro recorder first you will see the VBA way. This message was edited by Andrew Poulsom on 2002-09-12 06:25