Excel - Single Quotation mark in CSV

Asked By hon123456

30-Nov-08 06:04 PM

Dear all,

I have create a CSV file with two columns, The data is as
below

AAA,'001
AAA,'002
AAA,'003

The reason for me to add a single quote in the second
column is I want to kept the
leading zero of the data. But when I open the CSV file with
Excel. I still see the single
quotation mark in the second column, What I want is Excel
keep the leading zero but
do not show the single quotation mark when I open it. Just
like there is a green little
triangle in the cell left upper conner when we type single
quotation mark in Excel.

Thanks

Please Help.

29-Nov-08 02:49 AM

Hi,

One thing you could do is save the file as a TXT file and drop the
appostrophies, then when you open it the Import Wizard will appear, on the
last step of the wizard select the column whose leading 0's you want retained
and choose the option Text.

This will save you having to type a lot of 's

If this helps, please click the Yes button.

Cheers,
Shane Devenshire