The problem stems from if Excel sees the imported value as all numbers, it treats it as a number. The only way I've found is to use a template that sets the format to for the column to Text, or to use automation to set the column to Text BEFORE you import the data.
Fred On Mon, Aug 22, 2011 at 11:02 AM, 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 > To: profoxt...@leafe.com > Subject: Re: FoxPro to Excel & Exponential Looking Data > > 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... > > > > > > > > I have this one utility that needs to export data to Excel. Which, for > > the most part - it does it just fine. The problem is, I need to be > able > > to export this like a FedEx or UPS Tracking # that the user must > enter. > > And, if that tracking number is big and all digits (like 18 digits > long) > > - when you open the Excel file - those tracking numbers get displayed > as > > some kind of Exponential number. > [excessive quoting removed by server] _______________________________________________ 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/CAJCBksqwUgKxfk=D5EZXZwr=rd2fmqqh-cf0qdxcalwozdy...@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.
