Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel | |||
How can I import a text file into excel with each field as a sepe. | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) | |||
How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions | |||
Parsing text in Excel | Excel Worksheet Functions |