title: format cell values to phone number format
body: <p>I have phone numbers listed in Column A of Sheet1. Currently they dont have any format and are stored as: 1112223333</p>
  
  <p>I want to convert them to: 111.222.3333</p>
  
  <p>I tried:</p>
  
  <pre><code>Format(Worksheets("Sheet1").Range("A1").Value, "###.###.####")
  </code></pre>
  
  <p>which gives me "1112223333.." </p>
  
  <p>EDIT:
  When I try to format it to: </p>
  
  <pre><code>Format(Worksheets("Sheet1").Range("A1").Value, "(###) ###-####")
  </code></pre>
  
  <p>It works perfectly fine: (111) 222-3333</p>
  
  <p>Its just with the "111.222.3333" format that I am having issues with. Am I missing something here?</p>
  
  <p>Thanks in advance</p>