I'm new here and apologize if this is a noob question, but i've spent a solid 20 minutes trying to find a solution online, or previous question similar to this. I have a large inventory data dump from a supplier that I want to import into my system. The problem is all the numbers in the "vendorpart#" column are 5 or 6 digits depending on the part number. However, the part number sequence needs to be 10 digits, no more no less, with the balance as zeros infront. example (0000123456, or 0000012345).
Below is a link to a sample of the cells I've filled in some of them for example manually but have thousands more too go. rather than doing this manually, there has to be a function or cell format that can auto-fill this for me? Any suggestions would be immensely appreciated.
VendorPart Number example: https://www.dropbox.com/s/g7310nlmeafdb3g/Vendor%20PN.JPG?dl=0&m=
Formula Bar value not matching the cell value: https://www.dropbox.com/s/bbwskm1nl95a4pp/Formula%20bar%20value.png?dl=0&m=