I have a very large file with valid numbers of 02, 002, 02.1. The file has 002, 0002, 002.1 - how do I remove just the first leading zero but keep the rest. There are also number without leading zeros so I can not use the text to column process. Is there a way to do this in VBA or Excel formula?