title: EXCEL > how to refresh a cell to apply new cell format?
body: <p>I have a value in a cell, say <code>123456789.12345</code>. By default excel shows this as <code>123456789.1</code>. I need to see all digits after comma, so I change cell format to custom <code>&gt; @</code></p>
  
  <p>To apply this change I need to refresh the cell, for example select it and press <code>F2</code>, then Enter. But how to apply this refresh for a column or a range?</p>
  
  <p>No VBA if possible please.</p>