csv output

[Ken Cole]

the single inverted comma is the Excel string marker -> '

However, I don't think excel recognises it in a csv file as anuthing else
than a valid character.

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.

Ken

On Sat, Feb 28, 2009 at 4:01 AM, Fairlight <fairlite at fairlite.com> wrote:

> With neither thought nor caution, Richard Kreiss blurted:
> > Have a small problem and I am sure one of you can answer this.
> >
> > I am outputting a value 6 and a letter.  If the value is either an A or
> P,
> > when excel reads in the value, it converts to a time.
> >
> > Any idea how to avoid this?
>
> If memory serves, preceed your value with a single doublequote to have it
> taken as a string literal.
>
> I'm assuming you mean it's being converted in Excel.  If not, ignore the
> above.
>
> mark->
> --
> "I'm not subtle. I'm not pretty, and I'll piss off a lot of people along
> the way. But I'll get the job done" --Captain Matthew Gideon, "Crusade"
>  _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090302/00cce8c8/attachment.html