Ted - you're right - I failed to mention that I specifically export the data as a CSV file using COPY TO.
Now - when my QA Tech was originally playing around with the exported data - and opened it up in Excel, we found that by putting the quote at the beginning of the number - that Excel did indeed treat it as just characters - and stopped doing the Exponential display stuff. So - since that seemed to work - and you also mentioned doing the same thing from within VFP - that's what I just implemented. It should do the trick - I didn't actually test it to see if it works - since they have me juggling TOO Many things here - so, I left it for my QA Tech guy to test it out and get back to me. Thanks to you and ALL the others who responded! As usual - this list is ALWAYS a Great help! -K- -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Monday, August 22, 2011 2:11 PM You don't mention how you're moving the data to Excel: exporting from VFP as CSV, opening the DBF in Excel, or one of the many other ways. What if you were to prepend a single quote to the field in VFP before you exported the data? That's the usual signal to excel to treat what follows as string even if it is all numbers. On Mon, Aug 22, 2011 at 2:02 PM, Kurt Wendt <kurtwe...@waitex.com> wrote: > Actually - the field that I am exporting already IS a Character field! > -K- > > -----Original Message----- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of Sytze de Boer > Sent: Monday, August 22, 2011 1:55 PM > > Does it still happen if you turn the number into a character string ? > > > On Tue, Aug 23, 2011 at 5:50 AM, Kurt Wendt <kurtwe...@waitex.com> > wrote: >> I looked thru all the old e-mails I got from ProFox and could not seem >> to find this. Even though I am SURE someone in the group mentioned > this >> problem - and somewhat recently. Oh well, here goes... _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140b7cd...@us-ny-mail-002.waitex.net ** 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.
