How to access the literal content of a cell, regardless datatype

[deyken]

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.

[Aflatoon]

What field type is the database field? I would suspect numeric.