When I import spreadsheets from Excel into Access that contain telephone numbers they sometimes come through as Scientific notation or as a resolved equation.
e.g. 123-456-7890 might come through as a negative number because it preforms the 2 subtractions.

or, it might look like "123.456e+011"

Sometimes converting the column in Excel as Numeric with 0 decimal places helps. I tried setting the sheet to display formulas, looks good but still has problems after I import to Access.

Any ideas on this?
Thanks, DaveBo