[DUG] Exporting to excel autoformat

[Gary T. Benner]

[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
>

Ref#: 41006

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20090915/cadf3dd1/attachment.html