Changing format number

jpen

Active Member
Joined
Jun 19, 2002
Messages
393
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

jpen

Active Member
Joined
Jun 19, 2002
Messages
393
Andrew,

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

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,308
Members
412,716
Latest member
thviid
Top