When exportiing a excel sheet where the cells are formated as text it drops the leading zero's. Ex: Zipcode: 01701 Export to 1701 I export by using the Excel save as and selecting file type dbase iv. Thanks in advance for help. Mike
Here's what the Excel Help file says: Data types of values in the first row of data in the converted range determine the data types of each field (column) of data. If the first row of data contains a blank value for a field, the field is converted as a text field, even if subsequent rows contain numbers in that field; the numbers are converted as text. So maybe check what is being used to identify the data type.... Or maybe you could export to .csv and read that in instead? Good Luck! ----------------------------------------------------------------- "msegal" wrote: > When exportiing a excel sheet where the cells are formated as text it drops > the leading zero's. Ex: Zipcode: 01701 Export to 1701 > > I export by using the Excel save as and selecting file type dbase iv. > > Thanks in advance for help. > > Mike
