Pad the number with dashes : REPT « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. REPT
Input the formula: =REPT("-",25-LEN(TEXT(A1,"$0.00*-")))&TEXT(A1,"0.00*-")
Input the formula: =REPT








22.18.REPT
22.18.1.REPT(text,number_times) repeats text a given number of timesREPT(text,number_times) repeats text a given number of times
22.18.2.Pad the number with asterisks on the leftPad the number with asterisks on the left
22.18.3.Display asterisk padding on both sides of the numberDisplay asterisk padding on both sides of the number
22.18.4.Display the value along with the asterisk padding on the left:Display the value along with the asterisk padding on the left:
22.18.5.Pad the number with dashesPad the number with dashes
22.18.6.To pad the number with asterisks, use two asterisksTo pad the number with asterisks, use two asterisks