View Single Post
  #1   Report Post  
Rick
 
Posts: n/a
Default Auto insert values?

I am importing a .csv file and wish to have cells populate a default length
in width. If the cell doesnt take up the whole width, I would like to have
zeroes (or some other value) inserted at the beginning. Example: the cell
needs to be 8 characters, the number importing is only 4 and I wish to add 4
zeroes in front such as 00001234 automatically. How would I accomplish this?