* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [140305, 16:53]: > I need very much of help in importing text file into OpenOffice Calc, > because i have a text file with fixed width columns, and the numbers are > thousand separated by "," and decimal separated by "," and i'm not able to > import it into OpenOffice Calc, with the numbers as numbers. >
Hi Marcelo, I don't think you can have 'numbers' with the same separator: either you have '.'(point) separated thousands with ','(comma) separated decimals or the reverse. So, probably, your original figures are not 'numbers'. Anyway, try: 1.) Format > Cells > Numbers and substitute 'Spanish (Spain)' for 'Default': this will cause Calc to use comma separated decimals in the particular spreadsheet you are using. If that works and you want to set it for all Calc's, do 2.) Tools > Options > Language Settings and choose Spanish as the Loale Setting (instead of Default). If 1.) doesn't work, I'm afraid you must eliminate the comma separating thousands ;) HTH, Ennio. -- [Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�) [Why use Win$ozz (I say) if ... "even a fool can do that. )=( Do something you aren't good at!" (as Henry Miller used to say) ] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
