csv output

Fairlight fairlite at fairlite.com
Fri Feb 27 10:01:32 PST 2009


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"


More information about the Filepro-list mailing list