Re: CSV file and the delimiter

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Yes, Booth, if you take out the currency symbol. It'll even format the cell 
as Numeric, 2 decimal places, with commas, instead of General. I tested 
this by copying ths string below and pasting into Excel. Then making a 
version without the currency symbol and pasting that in.

HTH

Vern

At 10:37 PM 4/19/2003 -0400, you wrote:
> I'd be interested in some feedback on building CSV files.
>
> When one uses the comma delimiter one must deal with the possibility of
> embedded commas within the character data.   Enclosing character fields in
> matched quotes will deal with that, but what happens if you enclose all
> fields in matching quotes, even numeric fields?
>
> Will Excel accept a numeric column as numeric, even if its in quotes?  Would
> it understand that an edited numeric field  "-$1,000,000.00" is a negative
> number?
>
>
> ---------------------------------------------------------
> Booth Martin   http://www.MartinVT.com