Hi Pere, On Tue, Sep 13, 2005 at 08:27:09 +0200, Pere Castañer Sarda wrote:
> 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 it's really only about changing columns of xxx.yy to xxx,yy use Find&Replace after having imported the .xls: select column(s) to replace, open Edit.Find&Replace, search for '.' and replace with ',' (both without ' single quotes of course), in the MoreOptions check "Current selection only", click ReplaceAll. Done. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
