On Tue, Aug 23, 2011 at 4:47 PM, Kurt Wendt wrote:
> Ted - you're right - I failed to mention that I specifically export the
> data as a CSV file using COPY TO.
>
>
That's why after loads of similar problems i always let fp do the conversion
(copy to xl5) and take it from there.
A+
jml
--- Str
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 indee
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 i
+1
Le 22/08/11 20:10, Ted Roche a écrit :
> 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 usu
]
> 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, Ku
un...@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
LLC
Sent: Monday, August 22, 2011 1:57 PM
To: profoxt...@leafe.com
Subject: Re: FoxPro to Excel & Exponential Looking Data
On 8/22/2011 1:50 PM, Kurt Wendt 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 g
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
> wrote:
> > I looked thru all the old e
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
On 8/22/2011 1:50 PM, Kurt Wendt 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 da
Does it still happen if you turn the number into a character string ?
On Tue, Aug 23, 2011 at 5:50 AM, Kurt Wendt 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 rec
11 matches
Mail list logo
