Remove leading zeros and convert to number: For example, if you write the value 0009 in a cell, Excel automatically abbreviates it to 9. Preserve the first 15 digits of long numbers and convert it ...