Mark,<br><br>I think I finally got you on this one, Mark many Ken 1 :-(<br><br>A quick test shows:<br>Entering 123 in an Excel cell converst to a right aligned number 123<br>Entering '123 converts to a left aligned string 123<br>
Entering "123 converts to a left aligned string "123<br><br>To be honest I thought " did do something in Excel but now I am not too sure.<br><br>Ken<br><br><div class="gmail_quote">On Thu, Aug 13, 2009 at 12:35 AM, Fairlight <span dir="ltr"><<a href="mailto:fairlite@fairlite.com">fairlite@fairlite.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The honourable and venerable Ken Cole spoke thus:<br>
<div class="im">><br>
> Actually the ' character is the string literal for excel<br>
<br>
</div>I know better than to ask if you're sure. I guess my memory on that one<br>
was just a bit off. I know it's unbalanced, just had the wrong one I<br>
guess. I know you use it more than I do.<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>
_______________________________________________<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>
</font></blockquote></div><br>