title: How to Truncate a Double in VBA
body: <p>I have a variable in VBA that I need to truncate to 4 significant figures. I can't seem to find anything that won't round the number up or down. But I just want to remove the numbers after the 4th significant figure. I've tried, </p>
  
  <pre><code>compressibility = round(compress, -3 - (Int(Log(Abs(compress)))))
  </code></pre>
  
  <p>It removes the numbers after the 4th digit but it still rounds the number up.</p>
  
  <p>Compress is a number around 0.000245848385 as an example, and I need the compressibility number to be 0.0002458. </p>
  
  <p>Any suggestions would be great! Thanks.</p>