Saving Excel Data with Leading Zero's

When using an Excel spreadsheet as a source of data to be imported into a application (SQL, Acclamare, or some of database), a common problem is that regarding leading zero's. Your application needs the leading zero's to remain, as they are part of a "text" value. Excel on the other hand wants to identify the value as numeric and strip the zero's. Even if your "format" the cell, that is only controlling how the data is displayed with Excel, not how the underlying is stored. The attached document will provide instructions for extracting numeric data, and retaining the leading zeros.

Save Excel numeric data as text with leading zero..pdf

 I found this article helpful. (0)