<div>the single inverted comma is the Excel string marker -> '</div>
<div> </div>
<div>However, I don't think excel recognises it in a csv file as anuthing else than a valid character.</div>
<div> </div>
<div>Somethimes it is better to define the file name with .dat and Excel will not try to auto import it but starts an import wizard in which yo can set column data types so you could then set the type for this column to text and the problem would not occur.</div>
<div> </div>
<div>Ken<br><br></div>
<div class="gmail_quote">On Sat, Feb 28, 2009 at 4:01 AM, Fairlight <span dir="ltr"><<a href="mailto:fairlite@fairlite.com">fairlite@fairlite.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">With neither thought nor caution, Richard Kreiss blurted:<br>
<div class="Ih2E3d">> Have a small problem and I am sure one of you can answer this.<br>><br>> I am outputting a value 6 and a letter. If the value is either an A or P,<br>> when excel reads in the value, it converts to a time.<br>
><br>> Any idea how to avoid this?<br><br></div>If memory serves, preceed your value with a single doublequote to have it<br>taken as a string literal.<br><br>I'm assuming you mean it's being converted in Excel. If not, ignore the<br>
above.<br><br>mark-><br><font color="#888888">--<br>"I'm not subtle. I'm not pretty, and I'll piss off a lot of people along<br>the way. But I'll get the job done" --Captain Matthew Gideon, "Crusade"<br>
</font>
<div>
<div></div>
<div class="Wj3C7c">_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br>