title: Formatting an integer into a specific string format
body: <p>I was wondering of there was a way of formatting an integer (789) into a string value (7.8.9).</p>
  
  <p>Here is what I am currently doing to format the number:</p>
  
  <pre><code>Dim i as integer
  Dim s as String
  i = 789
  
  s = Left(i, 1) &amp; "." &amp; Mid(i, 2, 1) &amp; "." &amp; Right(i, 1)
  </code></pre>
  
  <p>Note: The integer value will always be a 3 digit number.</p>