Vår/Our ref: BS E70660 27 May 2007 Brian Thanks for a quick comment. I have the following -pc with Centrino Duo -Win XP with latest sp The file is -a file crated from a dos-program and cleaned in Notes I do the following -Insert sheet from file -character set western Europe Dos Nordic -fixed width -manually set the tabs to suit -OK and import Result as described. It is not possible to change the Format of the cells. The number does not come back to the original. The .csv form do the same as insert sheet from file. Summary Numbers like 30.1 turns to date format 30-01-01. Without the tabs the figures open correctly. I cannot use this as I do not get the columns required. The seem clearly to be a bug in the program. Do you need any more info to correct? Regards Bengt
>>> Brian Barker <[EMAIL PROTECTED]> 2007-05-27 14:01 >>> At 11:15 27/05/2007 +0200, Bengt Sebring wrote: >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 Excel. > >Vänliga hälsningar/Best regards >Bengt Sebring >Försäljningschef/Sales Manager >CHS Controls AB >Florettgatan 33 >SE-254 67 Helsingborg, Sweden I don't know why the format is setting itself to "Date", but you can change the format of cells fairly easily. Select the relevant cells (you can select a whole column at once or even a whole sheet, of course). The go to Format | Cells... (or use right-click and select Format Cells... from the context menu) and choose the Numbers tab. Select an appropriate category in the left window and a format in the central one. Select OK, and this should be applied to all the cells in your selection. I don't know how you are importing the text file (or whether you are using Windows - you don't tell us), but if you change the extension of a Widows text file to .csv and then open it with OpenOffice, you should get a Text Import window, allowing you to control how the import is handled. (I trust you will get this window however you are importing the material.) The format of each column is shown at the head of each column in the Fields area at the bottom of the window. If you click on each column in turn, you can set its format from the drop-down list in the "Column type" window above. Does changing this back from "Date" to "Standard" solve the problem? I trust this helps. Brian Barker
