What is the meaning of a lead apostrophe in an Excel file cell that causes incorrect formatting when reading in the import Excel file?
Posted on 2014-09-24
I am using Excel 2010.
In worksheet SampleA, I look at 1 cell, A14, and the value in the cell is 09/22/2014 and its correspoding value in the formula bar is 9/22/2014. If I look at Fomat Cells, under the Number tab, I see
In the same workbook, in worksheet SampleB, I look at cell, A14, and the value in the cell is 09/22/2014 and its corresponding value in the formula bar is '09/22/2014. If I look at Format Cells, under the Number tab, I see:
What causes the formula bar value in the 2nd worksheet to begin with 1 leading ' (apostrophe) before the date?
This leading apostrophe seems to be responsible for causing this particular records from being imported from an Excel record into a Sybase table. This record is bypassed for what seems to be a formatting error.