| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
disabling default "text to columns" while *.csv file opening
Does anybody knows how to disable this "feature" - every time I open csv file
I get it opened with text to columns sorted, the problem is that this does data format check while opening and does not allow to change format of cells.. I found one workaround - to import data to blank sheet but this is annoyinig and time consumptive (I have to open a lot of csv files every day). Does anybody knows how to disable it? I would be happy if I could just open ths csv file and have data unsorted, in one cell delimited with semicolon.. I've performed some diig for answer through the websites - changing file extension does not help, neither opening it with shift pressed, I do not have KB943985 installed and hotfix for that does not solve this issue.. Please help me cause now I am running out of new ideas how to get rid of this annoying thing. Thank you all in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
| Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) | |||
| How to open CSV file in XLS without going to "Text to columns"? | Setting up and Configuration of Excel | |||
| .csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) | |||
Threaded Mode
