Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Display the value along with the asterisk padding on the left

Input the formula: =REPT("*",24-LEN(TEXT(A1,"0.00")))&TEXT(A1,"0.00")