View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hon123456 hon123456 is offline
external usenet poster
 
Posts: 31
Default Single Quotation mark in CSV

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.