<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD><TITLE>myOffice Email Message</TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="country-region"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PersonName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Helvetica;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: MS Sans Serif;
}
@font-face {
font-family: Webdings;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-FAMILY: "Times New Roman"; MARGIN-LEFT: 0cm; FONT-SIZE: 12pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
FONT-FAMILY: Arial; COLOR: navy; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
<META name=date content=2002-11-01></HEAD>
<BODY lang=EN-GB link=blue vLink=blue>
<DIV dir=ltr align=left><SPAN class=938424701-15092009><FONT color=#0000ff
face=Tahoma>Sounds like your export environment does all or no fields - can you
not specify only certain fields?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=938424701-15092009><FONT color=#0000ff
face=Tahoma>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=938424701-15092009><FONT color=#0000ff
face=Tahoma></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=938424701-15092009><FONT color=#0000ff
face=Tahoma>Hope this helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=938424701-15092009><FONT color=#0000ff
face=Tahoma>Daryl</FONT></SPAN></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> delphi-bounces@delphi.org.nz
[mailto:delphi-bounces@delphi.org.nz] <B>On Behalf Of </B>Ayers,
Stephen<BR><B>Sent:</B> Tuesday, 15 September 2009 13:12<BR><B>To:</B> Gary T.
Benner<BR><B>Cc:</B> delphi@delphi.org.nz<BR><B>Subject:</B> Re: [DUG]
Exporting to excel autoformat<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT color=navy size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">I have already tried
this, and yes that works, but now I have double quote around all my numbers
which I do not want.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=navy size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><STRONG><B><FONT color=black size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt">Steve
Ayers</SPAN></FONT></B></STRONG><B><FONT color=black size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: bold"><BR><STRONG><B><FONT
face=Arial><SPAN style="FONT-FAMILY: Arial">Analyst
Programmer</SPAN></FONT></B></STRONG><BR><BR><STRONG><B><FONT face=Arial><SPAN
style="FONT-FAMILY: Arial">FUJITSU <st1:country-region w:st="on"><st1:place
w:st="on">NEW
ZEALAND</st1:place></st1:country-region></SPAN></FONT></B></STRONG></SPAN></FONT></B><FONT
color=black size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt"><BR><st1:address
w:st="on"><st1:Street w:st="on">PO Box</st1:Street> 493</st1:address>,
Palmerston North Central, Palmerston North 4440<BR><STRONG><B><FONT
face=Arial><SPAN style="FONT-FAMILY: Arial">T</SPAN></FONT></B></STRONG> +64 6
953 6807 <BR><A href="mailto:stephen.ayers@nz.fujitsu.com"><FONT
color=black><SPAN
style="COLOR: black">stephen.ayers@nz.fujitsu.com</SPAN></FONT></A><BR><A
href="http://nz.fujitsu.com"><FONT color=black><SPAN
style="COLOR: black">nz.fujitsu.com</SPAN></FONT></A><BR></SPAN></FONT><FONT
color=navy><SPAN style="COLOR: navy"><BR></SPAN></FONT><FONT color=#999999
size=1 face=Webdings><SPAN
style="FONT-FAMILY: Webdings; COLOR: #999999; FONT-SIZE: 8pt">P</SPAN></FONT><FONT
color=#999999 size=1 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: #999999; FONT-SIZE: 8pt"> Please consider
the environment before printing this email</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center><FONT size=3
face="Times New Roman"><SPAN style="FONT-SIZE: 12pt" lang=EN-US>
<HR tabIndex=-1 align=center SIZE=2 width="100%">
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT size=2 face=Tahoma><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; FONT-WEIGHT: bold"
lang=EN-US>From:</SPAN></FONT></B><FONT size=2 face=Tahoma><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt" lang=EN-US> Gary T. Benner
[mailto:gary@benner.co.nz] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, 15 September 2009 1:05
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Ayers,
Stephen<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> <st1:PersonName
w:st="on">delphi@delphi.org.nz</st1:PersonName><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [DUG] Exporting to excel
autoformat</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><FONT size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><B><FONT color=red size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: red; FONT-SIZE: 12pt; FONT-WEIGHT: bold">[Reply]</SPAN></FONT></B>
<o:p></o:p></P>
<P><FONT color=black size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 12pt">HI
Stephen,</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=black size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 12pt">Surround
the data in double quotes when exporting. This forces Excel to treat it as
text.</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=black size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 12pt">kr</SPAN></FONT>
<o:p></o:p></P>
<P><st1:City w:st="on"><st1:place w:st="on"><FONT color=black size=3
face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 12pt">Gary</SPAN></FONT></st1:place></st1:City>
<o:p></o:p></P>
<P><FONT color=black size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 12pt">A</SPAN></FONT><B><FONT
color=red face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: red; FONT-WEIGHT: bold">t 12:53 on
15/09/2009 you wrote </SPAN></FONT></B><o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>To :
<st1:PersonName w:st="on">delphi@delphi.org.nz</st1:PersonName></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>CC :
</SPAN></FONT><o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>From:
Ayers, Stephen, Stephen.Ayers@nz.Fujitsu.com</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Content
Type: text/plain</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Attached:
</SPAN></FONT><o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Hi</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>We
have an option to export out reports to excel rather than to
screen.</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>An
issue I have come across is that some fields are getting auto</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>formatted
to dates. For example 200438-2 gets turned into 01/02/3830.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Yet
456381-1 doesn't. I don't want any of these fields turning into</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>dates.
Has anyone come across this issue before when importing into</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>excel.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>thanks
</SPAN></FONT><o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>The
information contained in this email is privileged and confidential
and</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>intended
for the addressee only. If you are not the intended recipient,
you</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>are
asked to respect that confidentiality and not disclose, copy or make
use</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>of its
contents. If received in error you are asked to destroy this
email</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>and
contact the sender immediately. Your assistance is appreciated.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>_______________________________________________</SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>NZ
Borland Developers Group - <st1:place w:st="on">Delphi</st1:place> mailing
list</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Post:
<st1:PersonName w:st="on">delphi@delphi.org.nz</st1:PersonName></SPAN></FONT>
<o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Admin:
http://delphi.org.nz/mailman/listinfo/delphi</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">>Unsubscribe:
send an email to delphi-request@delphi.org.nz with Subject:
unsubscribe</SPAN></FONT> <o:p></o:p></P>
<P><FONT color=green size=3 face="MS Sans Serif"><SPAN
style="FONT-FAMILY: 'MS Sans Serif'; COLOR: green; FONT-SIZE: 12pt">></SPAN></FONT><o:p> </o:p></P>
<P><FONT color=gray size=1 face=Helvetica><SPAN
style="FONT-FAMILY: Helvetica; COLOR: gray; FONT-SIZE: 7.5pt"><BR><BR></SPAN></FONT><FONT
color=black size=2 face=Helvetica><SPAN
style="FONT-FAMILY: Helvetica; COLOR: black; FONT-SIZE: 10pt">Gary Benner
</SPAN></FONT><FONT color=gray size=1 face=Helvetica><SPAN
style="FONT-FAMILY: Helvetica; COLOR: gray; FONT-SIZE: 7.5pt"><o:p></o:p></SPAN></FONT></P>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center><FONT color=gray
size=1 face=Helvetica><SPAN
style="FONT-FAMILY: Helvetica; COLOR: gray; FONT-SIZE: 7.5pt">
<HR align=center SIZE=2 width="100%">
</SPAN></FONT></DIV>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><FONT color=gray size=1
face=Helvetica><SPAN
style="FONT-FAMILY: Helvetica; COLOR: gray; FONT-SIZE: 7.5pt"><BR><A
href="http://www.semantic.co.nz"><SPAN style="TEXT-DECORATION: none">Semantic
Limited</SPAN></A> - Online Education, e-Commerce, Software Development &
Systems Design<BR><BR><A href="http://www.123.net.nz"><SPAN
style="TEXT-DECORATION: none">123 Internet Limited</SPAN></A> - Managed Web
Hosting, Virtualisation, High Availability Systems & Cluster
Technologies<BR><BR><B><SPAN style="FONT-WEIGHT: bold">Mob:</SPAN></B> 021 966
992<BR><BR><B><SPAN style="FONT-WEIGHT: bold">DDI:</SPAN></B> +64 7 543
1206<BR><BR><B><SPAN style="FONT-WEIGHT: bold">Email:</SPAN></B> <A
href="mailto:gary@benner.co.nz">gary@benner.co.nz</A><BR><BR><B><SPAN
style="FONT-WEIGHT: bold">Skype:</SPAN></B>
garybenner<BR><BR></SPAN></FONT><FONT color=navy size=1 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 7.5pt"><BR><BR>Ref#:
41006</SPAN></FONT><o:p></o:p></P></DIV><BR><FONT color=#0080c0
size=2><STRONG><EM>The information contained in this email is privileged and
confidential and<BR>intended for the addressee only. If you are not the
intended recipient, you<BR>are asked to respect that confidentiality and not
disclose, copy or make use<BR>of its contents. If received in error you are
asked to destroy this email<BR>and contact the sender immediately. Your
assistance is appreciated.</EM></STRONG></FONT> </BLOCKQUOTE><p>**********************************************************************<br />This email and any files transmitted with it are confidential and<br />intended solely for the use of the individual or entity to whom they<br />are addressed. If you have received this email in error please notify<br />the sender of the message.</p><p>This footnote also confirms that this email message has been swept by<br />MIMEsweeper for the presence of computer viruses.</p><p><a href="http://www.ecan.govt.nz">www.ecan.govt.nz</a><br />**********************************************************************</p>
</BODY></HTML>