I have a large list of numbers on tools.
Some of the tools numbers start with zeros.
When I have exported the list to Excel all the numbers in the beginning is missing.
Because of that I want to create a macro that searches for these numbers and replaces it with the correct one.
For exampel if the number 22 occurs in column D and/or E it would be replaced with the number 0022.
I have attached an exampel bok.