[DUG] Exporting to excel autoformat

[Daryl Marsden]

Sounds like your export environment does all or no fields - can you not
specify only certain fields?
When "importing" with XL make sure you specify "parsing" to force text
on certain columns - don't just open the file with XL or you may get
unexpected results.  Our Accountants often open csv files with XL -
stripping off leading zeros on codes.  To "import", unfortunately, you
must navigate to the folder to find your file - not good if you want to
quickly work on a whole bunch of files.
 
Hope this helps,
Daryl


________________________________

	From: delphi-bounces at delphi.org.nz
[mailto:delphi-bounces at delphi.org.nz] On Behalf Of Ayers, Stephen
	Sent: Tuesday, 15 September 2009 13:12
	To: Gary T. Benner
	Cc: delphi at delphi.org.nz
	Subject: Re: [DUG] Exporting to excel autoformat
	
	

	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. 


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20090915/29202ce4/attachment.html