Jun 03 2020 02:49 AM
@rleggi Your "numbers" with leading zeros ar in fact texts. You can convert them to numbers like in the formula below and copy it down (assuming your first "number" is in A1.
=--A1
or,
=VALUE(A1)
if you prefer a more traditional formula.