deyken
01-19-2012, 11:50 PM
Hi All,
I am trying to access a column in Excel, where the content has been literally typed as "'04505", with the leading ' to make numbers with leading zeros show those zeros.
I am uploading this column's data into a database, but when it has been uploaded, the data in the DB Table truncated the leading zero. How can I access the contents of an Excel worksheet Cell "as-is"?
I tried formatting these cells as "Text", but it did not work. The leading zeros are still being truncated.
I am trying to access a column in Excel, where the content has been literally typed as "'04505", with the leading ' to make numbers with leading zeros show those zeros.
I am uploading this column's data into a database, but when it has been uploaded, the data in the DB Table truncated the leading zero. How can I access the contents of an Excel worksheet Cell "as-is"?
I tried formatting these cells as "Text", but it did not work. The leading zeros are still being truncated.