title: How do I call a function to add/remove dots and dashes on a given cell
body: <p>Here in Brazil we use a 20 number string to identify judicial cases, in a standardized manner, separated by a dots and dashes.</p>
  
  <p>The problem is in most systems we use, when you export to excel it takes away the dots and dashes, thus creating a problem when exporting that data to a system that actually needs the dots and dashes to work (some poorly coded excuse for a legal system).</p>
  
  <p>What I'm trying to do is use VBA to call a function that fixes the number so I can export it.</p>
  
  <p>The way the standardized number works is like this:</p>
  
  <blockquote>
    <p>0010159-24.2015.8.10.0001<br>
    (CaseNumber-VerifyingDigit.Year.Court.State.City)</p>
  </blockquote>
  
  <p>When I export my current data do Excel, it shows like this:</p>
  
  <blockquote>
    <p>00101592420158100001</p>
  </blockquote>
  
  <p>And I need it to go back to the format above!</p>
  
  <p>I'm 100% stuck though, would love some input.</p>
  
  <p>Edit:</p>
  
  <p>To clarify some stuff.</p>
  
  <p>The string is always 20 numbers long, its a standardized number set by our National Council of Justice, it never changes. All the cases follow that 20 number string format.</p>
  
  <p>The cell with the number is always in text, so it doesn't show as scientific notation.</p>