Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Display asterisk padding on both sides of the number

Input the formula: =REPT("*",12-LEN(A1)/2)&A1&REPT("*",12-LEN(A1)/2)