Change point in cooma in number

[jpen]

I have a file in which the numbers have a point as a decimal seperator. I'am using normally a comma as seperator.

How can I change this using a macro.

 

[Andrew Poulsom]

Without a macro:

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

Addendum:

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