title: excel 2007: append certain characters to value in a column to make it proper lenght
body: <p>I have following values in a column :</p>
  
  <p>123
  456
  789
  65
  1</p>
  
  <p>I want to append correct number of zeros in all the values in that column such that the total length of character is 5.</p>
  
  <p>00123
  00456
  00789
  00065
  00001</p>
  
  <p>How do I do that?</p>