yes i know it works, but the numbers with thousand separator "," and decimal separator "." are not recognized as numbers, but as text. And when the numbers are separated the other way(thousand separator "." and decimal separator ",") everything works fine. One other thing is the negative sign is on the back side of the number is doesn't considear it.
my file has this type of numbers " 100,253.20- " how can i import it?? > On Thu, 17 Mar 2005 10:07:04 -0000 (WET) > [EMAIL PROTECTED] wrote: > > MP> Yes but my fields are not separated by anything i have fiels fixed > MP> sized width numbers with thousand separator "," and decimal > MP> separator "." > > There is an option for fixed-width fields -- you need to manually place > the column boundaries but it works. > > James > > -- > +------------------------+-------------------------------+---------+ > | James Tappin | School of Physics & Astronomy | O__ | > | [EMAIL PROTECTED] | University of Birmingham | -- \/` | > | Ph: 0121-414-6462. Fax: 0121-414-3722 | | > +--------------------------------------------------------+---------+ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
