On Mon, 12 Sep 2005 18:32:08 +0200 Eike Rathke <[EMAIL PROTECTED]> wrote:
> Hi Pere, > > On Mon, Sep 12, 2005 at 15:44:36 +0200, Pere Castañer Sarda wrote: > > > No. I need to convert the exported cells (from a closed source > > software) plenty of char text representing numbers with the format > > XXXXX.XX to XXXXX,XX > > In case you're importing a Text/CSV file, during import in the import > dialog you can set a column type to "US English", does that help? > Yes. In fact it is the method that I'm dealing with the exported data. The procedure is like this: First: I export the cells from my closed source program to .xls file format. Second: I import it in OO Calc2 Third: I save as .csv (Coma Separated Values) setting the cell delimiter one distinc from "," Fourth:I close the file, and I reopened and I set the same delimiter as I've put before AND SELECTING THE COLUMNS THAT I NEED TO OPERATE ARITMETICALLY TO "US ENGLISH TYPE". The procedure is a litle tricky but works. The real pity of all of this is about the existence of a tool like text2column macro and the feature of choosing the decimal separator char is missing. If this weekend I've a moment I'll check the source code to determine if I'm able to revise the code of Paolo Mantovani (But I haven't much hope that I can modify any bite...) regards, -- Pere Castañer Sardà Servei informàtic DIBOSCH S.L --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
