You don't indicate how you are currently exporting data and subsequently opening in Excel.
You could try putting a single quote in front of the tracking number but then you probably will see that as part of the value in that cell. The trick I've found with keeping Excel from being so helpful is to apply a custom/special format to the column. If you're in Excel, select the column; click Format Cells from the menu and pick Zip Code from the types. If you do decide to use automation, you would do something like this: .Columns(<column number of your tracking numbers>).NumberFormat=[00000] It won't truncate anything and will prevent Excel from turning you tracking numbers into exponents. -- rk ----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Monday, August 22, 2011 1:50 PM To: profoxt...@leafe.com Subject: FoxPro to Excel & Exponential Looking Data 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. I'm sure others have run into the problem. So - what is the best solution for this issue? I know I can do some Office Automation to fix it - but, I would rather avoid Automation - for many of the obvious reasons and drawbacks for going that route. Thanks, -K- _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD04419F2A660FE@ACKBWDDQH1.artfact.local ** 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.
