Result = **********

=REPT(”*”,10)

=IF(LEN(Number)<10,REPT(0,(10-LEN(Number)))&Number,TEXT(Number,”0?))

 

This formula literally steps along as:

 

If the length of [Number] is less than 10, create an amount of zero’s equaling the difference between 10 and the length of [Number] then display these zero’s followed by the [Number]. If the length of [Number] is not less than 10, display the number using the “TEXT()” formatting option to display it in a number format.

 

Examples:

Number = 12345
Result = 0000012345

Go to the main page