Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Pad the number with dashes

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