[DUG] Exporting to excel autoformat

[Ayers, Stephen]

I have already tried this, and yes that works, but now I have double
quote around all my numbers which I do not want.

 

Steve Ayers
Analyst Programmer

FUJITSU NEW ZEALAND
PO Box 493, Palmerston North Central, Palmerston North 4440
T +64 6 953 6807 
stephen.ayers at nz.fujitsu.com <mailto:stephen.ayers at nz.fujitsu.com> 
nz.fujitsu.com <http://nz.fujitsu.com> 

P Please consider the environment before printing this email

________________________________

From: Gary T. Benner [mailto:gary at benner.co.nz] 
Sent: Tuesday, 15 September 2009 1:05 PM
To: Ayers, Stephen
Cc: delphi at delphi.org.nz
Subject: RE: [DUG] Exporting to excel autoformat

 

[Reply] 

HI Stephen, 

Surround the data in double quotes when exporting. This forces Excel to
treat it as text. 

kr 

Gary 

At 12:53 on 15/09/2009 you wrote 

>To : delphi at delphi.org.nz 

>CC : 

>From: Ayers, Stephen, Stephen.Ayers at nz.Fujitsu.com 

>Content Type: text/plain 

>Attached: 

> 

> 

>Hi 

> 

>We have an option to export out reports to excel rather than to screen.


>An issue I have come across is that some fields are getting auto 

>formatted to dates. For example 200438-2 gets turned into 01/02/3830. 

>Yet 456381-1 doesn't. I don't want any of these fields turning into 

>dates. Has anyone come across this issue before when importing into 

>excel. 

> 

>thanks 

>The information contained in this email is privileged and confidential
and 

>intended for the addressee only. If you are not the intended recipient,
you 

>are asked to respect that confidentiality and not disclose, copy or
make use 

>of its contents. If received in error you are asked to destroy this
email 

>and contact the sender immediately. Your assistance is appreciated. 

> 

>_______________________________________________ 

>NZ Borland Developers Group - Delphi mailing list 

>Post: delphi at delphi.org.nz 

>Admin: http://delphi.org.nz/mailman/listinfo/delphi 

>Unsubscribe: send an email to delphi-request at delphi.org.nz with
Subject: unsubscribe 

> 



Gary Benner 

________________________________


Semantic Limited <http://www.semantic.co.nz>  - Online Education,
e-Commerce, Software Development & Systems Design

123 Internet Limited <http://www.123.net.nz>  - Managed Web Hosting,
Virtualisation, High Availability Systems & Cluster Technologies

Mob: 021 966 992

DDI: +64 7 543 1206

Email: gary at benner.co.nz

Skype: garybenner



Ref#: 41006


The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If received in error you are asked to destroy this email
and contact the sender immediately. Your assistance is appreciated.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20090915/42c6c34f/attachment-0001.html