2007/5/27, Bengt Sebring <[EMAIL PROTECTED]>:
Vår/Our ref: BS E70659 27 May 2007 When I try to import a txt-file into Open Office Calc some columns set themselves to date-format and it seem impossible to get back to the original numbers. The numbers are like 30.1 becomes 30-01-01. It seem to be the single decimal numbers that turn into date, not the double decimal numbers like 30.54. I am using a dos-format for the import, Nordic Dos. The problem makes it impossible to use Open Office Calc. I have to use MS Exel. Vänliga hälsningar/Best regards
I tried to work around this, but failed. My idea was to change the language of all cells to English (instead of Swedish in this case), then inserting table from file. The problem is that, when I made the CSV settings, I am asked wether the file is supposed to be inserted before or after the current sheet. There is no way to insert it IN the current sheet. I think that would solve this problem and maybe a few more problems as well. When language is set to Swedish, 30.1 is converted to 1930-01-01, which is a date following the Swedish (and international ISO 8601) date format. 1.30will show up as CurrentYear-01-30, in this case 2007-01-30 or just 07-01-30. Set the language to English, and 30.1 is just a number with a decimal point instead of the Swedish decimal comma. Setting the language back to Swedish will then cause 30.1 to be converted to 30,1. Isn't there a setting somewhere, something like "number recognition" that can be turned off? That would also solve the problem, I think. Johnny Andersson Sweden (which explains my lousy English)
