Text Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Text Functions
  4. To pad the number with asterisks, use two asterisks
=REPT("*",24-LEN(TEXT(A1,"0.00**")))&TEXT(A1,"0.00**")