Leading zeros can be dropped from Mfr Part Numbers in Excel if the part number is numeric and the cells in the Excel worksheet column are formatted as General, which is the default format in Excel. To preserve the leading zeros format the cells in the Excel template as text.
Example: Molex P/N 0039281043
Try the Generic XLS File Format to preserve leading zeros in part numbers.
You can find example BOM templates in the Parts Download.
That's it !
To speed up placing parts in your schematic from the Components Panel . . .
If you see pricing and stock then you have Parts Providers enabled.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfg2dOymV7b9rPHndcMyIGSFM00psjJK0bNby3yQwpeP7lYqU_8C_XQss8gGWuZykIsL0sYDVJ9JOidh3LuaKWkEqZf8AT1MQIBTEaoA935rYhyPoT8M6-9UOBWCho_1cq_1SuWodxaoM/s1600/2020-04-16+10_10_24.png)
Preferences > System > Network Activity > UnCheck Parts Providers.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIgyrZgBZMBtlo7LWDtk7dIEWmNco2usCBGbk2MKgEX_C2vQ0Jtw-MgdLXyvV2njJTyQ4avAUdlcT_6Qe6y2lSkYH9H87zQsdnejZU3-JErUqSlIH5pnMwU54978JD4tKR9qMbecHEYnU/s400/2020-04-16+10_23_39.png)
That's it !