Hi Klemens, Klemens Vierlinger <[EMAIL PROTECTED]> wrote:
> I want to open a text file (tab-delimited) which contains 'sep1' in > one cell. Both excel and scalc recognise this as a date and transform > it into 'Sep-01' and '09/01/06', respectively. Open the file this way: File -> Open -> mark the file -> -> select File type: Text CSV (*.csv;*.txt), click Open. Text import dialog window appears. In the "Fields" section, click on a column, and change "Column type" to "Text" instead of "Standard". Repeat this for all the columns, and open the file. > How can I turn off all AUTOwhatever features. I do not want my > spreadsheet-editor to do any thinking for me!! I've clicked through > tools -> opions but couldnt find anything. I've turned off everything > in tools -> AutoCorrect, but the problem persists. Another feature you can turn off is Tools -> Cell Contents -> Autoinput. Regards, Andrius --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
