T

#### Tom

part numbers which are generally 12 digit numbers, sometimes import in

scientific notation format as exponents. It seems very random. It obviously

happens in the excel spreadsheet also prior to import. If I click on the

field and look at the number in the formula bar however it appears normal.

Here is the question:

If I import a set of part numbers and 90% of them are 12 digits can I

control the formatting during the import process some way so that all numbers

end up as 12 digits? Also, if a number should only have 11 digits for what

ever reason, is there a way to make access add a zero to the first digit to

make it a 12 digit string?

Any help will be very appreciated