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.ay...@nz.fujitsu.com <mailto:stephen.ay...@nz.fujitsu.com> nz.fujitsu.com <http://nz.fujitsu.com> P Please consider the environment before printing this email ________________________________ From: Gary T. Benner [mailto:g...@benner.co.nz] Sent: Tuesday, 15 September 2009 1:05 PM To: Ayers, Stephen Cc: delphi@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@delphi.org.nz >CC : >From: Ayers, Stephen, stephen.ay...@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@delphi.org.nz >Admin: http://delphi.org.nz/mailman/listinfo/delphi >Unsubscribe: send an email to delphi-requ...@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: g...@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.
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
