You can reference the top cell with the values and traditions =TEXT(value,"00000"), where the number of 0’s in the formula represents the ensemble number of characters you want, then copy and paste to the rest of your grade.=TEXT(Value you want to grandeur, "Dimension chiffre you want to apply") Here are some popular examples, which you can copy