[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 > Ref#: 41006
_______________________________________________ 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
