<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>
myOffice Email Message
</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="date" content="2002-11-01">
<style type="text/css">
</style>
</head>
<body>
<span style=
"color:#FF0000 "><b><span style=
"font-family:MS Sans Serif ">[Reply]</span></b></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">HI Stephen,</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Surround the data in double quotes when exporting. This forces Excel to treat it as text.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">kr</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Gary</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">A</span><span style=
"color:#FF0000 "><b>t 12:53 on 15/09/2009 you wrote </b></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>To : delphi@delphi.org.nz</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>CC : </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>From: Ayers, Stephen, Stephen.Ayers@nz.Fujitsu.com</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Content Type: text/plain</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Attached: </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Hi</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>We have an option to export out reports to excel rather than to screen.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>An issue I have come across is that some fields are getting auto</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>formatted to dates. For example 200438-2 gets turned into 01/02/3830.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Yet 456381-1 doesn't. I don't want any of these fields turning into</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>dates. Has anyone come across this issue before when importing into</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>excel.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>thanks </span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>The information contained in this email is privileged and confidential and</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>intended for the addressee only. If you are not the intended recipient, you</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>are asked to respect that confidentiality and not disclose, copy or make use</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>of its contents. If received in error you are asked to destroy this email</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>and contact the sender immediately. Your assistance is appreciated.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>_______________________________________________</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>NZ Borland Developers Group - Delphi mailing list</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Post: delphi@delphi.org.nz</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Admin: http://delphi.org.nz/mailman/listinfo/delphi</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">>Unsubscribe: send an email to delphi-request@delphi.org.nz with Subject: unsubscribe</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#008000 ">></span></span><p>
<font face=arial size = 1 color = Navy><font color=gray face = "helvetica,verdana,arial" size = 1><br /><br>
<font size=2 color="black">Gary Benner </font><hr /><br>
<a HREF="http://www.semantic.co.nz" style="text-decoration:none; color:blue">Semantic Limited</a> - Online Education, e-Commerce, Software Development & Systems Design<br /><br>
<a HREF="http://www.123.net.nz" style="text-decoration:none; color:blue">123 Internet Limited</a> - Managed Web Hosting, Virtualisation, High Availability Systems & Cluster Technologies<br /><br>
<b>Mob:</b> 021 966 992<br /><br>
<b>DDI:</b> +64 7 543 1206<br /><br>
<b>Email:</b> <a href="mailto:gary@benner.co.nz" >gary@benner.co.nz</a><br /><br>
<b>Skype:</b> garybenner<br /><br>
</font><br>
<br>
Ref#: 41006<br>
<br>
</body>
</html>