Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Single quotation mark in Excel not showing up | Excel Discussion (Misc queries) | |||
Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
how to put quotation mark in each cell of the column | Excel Worksheet Functions | |||
what is single quotation mark left side of cell for | Excel Discussion (Misc queries) | |||
Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel |