title: How to show all decimal digits in an Excel cell programatically using VBA
body: <p>I have an Excel macro which stores some business values. </p>
  
  <p>For one of the cell the value should display 999.999999 but it shows 1000 and in formula bar i see the value shown as 999.999999. Since these are converted values from one type to another, the customer wants me to show the value as it is without the decimal places getting rounded.</p>
  
  <p>One workaround i thought was to convert the cell into text format before populating the value but this doesn't work as i need to support this in various regional settings.</p>
  
  <p>Any suggestions on how to get the Excel VBA to know the number of digits after decimal to be displayed will be a great help.</p>
  
  <p>Current code to populate cell value :</p>
  
  <p>Range.Offset(0,0).Value = Response</p>
  
  <p>Here, Response is the converted value i.e 999.999999 in string format.</p>