LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Single quotation mark in Excel not showing up PALady Excel Discussion (Misc queries) 2 April 3rd 23 04:36 PM
Single Quotation mark in CSV hon123456 Excel Discussion (Misc queries) 0 November 29th 08 05:15 AM
how to put quotation mark in each cell of the column crazyfisher Excel Worksheet Functions 17 October 16th 08 08:44 PM
what is single quotation mark left side of cell for Stache02 Excel Discussion (Misc queries) 4 January 11th 08 09:19 PM
Single or Double Quotation Mark and it comes up twice J.R.HOLMES Setting up and Configuration of Excel 1 December 31st 05 08:51 PM


All times are GMT +1. The time now is 12:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"