Hi yet again Georgee,

Not sure how familiar you are with Windows Explorer options but I thought
that I should include this so you are not delayed if you are not familiar
with it.

You will need to display the file extensions before you can change the
filename extension from csv to txt. To do this:-

Windows XP (and I think other versions prior to XP):-
Open windows explorer and change to the required folder
Select menu item Tools-Folder Options
Select the View tab
Under the Advanced settings heading, Uncheck Hide extensions for known file
types.

Windows Vista:-
Open windows explorer and change to the required folder
Select menu item Organize-Folder and Search options
Select the View tab
Under the Advanced settings heading, Uncheck Hide extensions for known file
types.

Also, I should have said before that you can simply select Text for all of
the columns in the Text to Columns dialog boxes and they will display as text
in the worksheet instead of other formats if that is what you are trying to
achieve.


Regards,

OssieMac