You can reference the top cell with the values and coutumes =TEXT(value,"00000"), where the number of 0’s in the formula represents the masse number of characters you want, then copy and paste to the rest of your range.Feedback will be sent to Microsoft: By nettoyage the submit button, your feedback will Si used to improve Microsoft products and … Read More