ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Text import wizard (https://www.excelbanter.com/excel-discussion-misc-queries/14616-excel-text-import-wizard.html)

Kate

Excel Text import wizard
 
Hello,

When you open up a .txt file in Excel, this starts up the Text import
wizard. On the second screen of the wizard, you get a set of delimiters to
choose from - Tab being the default. I have two people in which this is in
fact set to Comma delimited by default. Any ideas how to change the actual
default setting? (They want to get back to Tab delimited permanently!).
This is Excel2002 running on XP Professional, without SP2.

Cheers Mark



Peo Sjoblom

Look if they have different regional settings in windowsstart control
panel


--

Regards,

Peo Sjoblom


"Kate" wrote in message
...
Hello,

When you open up a .txt file in Excel, this starts up the Text import
wizard. On the second screen of the wizard, you get a set of delimiters

to
choose from - Tab being the default. I have two people in which this is

in
fact set to Comma delimited by default. Any ideas how to change the

actual
default setting? (They want to get back to Tab delimited permanently!).
This is Excel2002 running on XP Professional, without SP2.

Cheers Mark






All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com