title: How to format a column with this format: 000.000 in MS Access
body: <p>I have a column that I imported as text. It has numbers like 511.182, 367.340, 342.001, etc.</p>
  
  <p>I tried doing:</p>
  
  <pre><code>UPDATE databasename 
  SET accountcode = format(accountcode,"000.000")
  WHERE len([accountcode])&gt;0;
  </code></pre>
  
  <p>However, this just caused every row to have the last three digits after the period to be 000. In the example I gave, it would now show as: 511.000, 367.000, and 342.000</p>