Auto Format in Excel

In our company our part numbers contain dashes and are very inconsistent. Our numbers range from 8410-10-04, 12-1034 to 4023. The problem I am having is I take a list of numbers from our ERP to Access then to Excel and I loose the integrity of ourpart number.

1. I have added spaces

2. When removing spaces Excel automatically formats the cells begignning with 10-2356 to Oct 56.

I have had success using Trim, then Concatenate. The only problem is this is 2 more steps than I really want to deal with.

Is there a way to force excel not to automatically change the formating of my cells?