Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

To pad the number with asterisks, use two asterisks

=REPT("*",24-LEN(TEXT(A1,"0.00**")))&TEXT(A1,"0.00**")