Changing format number

[jpen]

Hi All,

I have a txt file which I import in Excel for further analyses. Only in the txt file a point is used for number seperation. Will I work with a comma. How can I change this by using a macro?

Thanks

 

[Andrew Poulsom]

See:

http://www.mrexcel.com/board/viewtopic.php?topic=21936&forum=2

 

[jpen]

Andrew,

I'am using Excel 97 and I don't find a "Advanced" button (step 3).

 

[Andrew Poulsom]

Oh dear!

One way is:

1. Select the data and choose Edit, Replace from the menu. Replace . with @
2. Repeat, replacing , with .
3. Repeat replacing @ with ,

If you record your actions you will be able to automate it for future use.