I only dabble with Excel but I suspect that you can get your expected results by setting it up to use five decimal places instead of two. I thought you could convert it in Foxpro with str(val( '12345.56'), 10, 5) but for some reason that only gives 4 decimal places even with decimals set to 6. I guess that leaves string manipulation where you find the location of the dot from the right edge of the trimed string with the RAT function and add as many zero as you need.
I'm curious why the extra zeros are important. Joe On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer <sytze.k...@gmail.com> wrote: > I have a problem and I hope someone can help > > I export 3 fields to a CSV file > Code C(15), price N(10,2) , supcode C(30) > > The code and the supcode may be pure numbers > Example supcode may be 12345.56000 > > I make some changes to the price (using Excel) > I now import from this same file and the supcode has changed to 12345.56 > > Whats the best way to overcome this? > > -- > Kind regards, > Sytze de Boer > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cabqednxphah_zgp+cmmh5tpop9xxrmj2cxifguzbcmh6bbr...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
