Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Pad the number with asterisks on the left

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