| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
interpreter .csv files (when opening .csv) should be configurable
Whenever I open a .csv file that is ; delimited by doubleclicking it in
windows explorer, excel automatically interprets it as comma delimited. I'd like to be able to either turn off the automatic interpreter (f.ex. by holding the CTRL button when opening a file) or change the default interpreting settings. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
interpreter .csv files (when opening .csv) should be configurable
Can you change the extension to .TXT?
When you open the *.TXT file, the Text Import Wizard will pop up and allow you to designate the format. Gord Dibben MS Excel MVP On Mon, 7 Dec 2009 02:21:01 -0800, MFvGeel wrote: Whenever I open a .csv file that is ; delimited by doubleclicking it in windows explorer, excel automatically interprets it as comma delimited. I'd like to be able to either turn off the automatic interpreter (f.ex. by holding the CTRL button when opening a file) or change the default interpreting settings. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
interpreter .csv files (when opening .csv) should be configurable
Don't open it by double-clicking.
Use Data/ Import External Data ... -- David Biddulph "MFvGeel" wrote in message ... Whenever I open a .csv file that is ; delimited by doubleclicking it in windows explorer, excel automatically interprets it as comma delimited. I'd like to be able to either turn off the automatic interpreter (f.ex. by holding the CTRL button when opening a file) or change the default interpreting settings. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
| Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
| Opening Files | Excel Discussion (Misc queries) | |||
| opening files | Excel Discussion (Misc queries) | |||
| How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Linear Mode
