title: VBA change string with decimal to number with decimal
body: <p>I have a field in an access database as TEXT. the text has decimals such as 100.00000. need to run calcs on these with the decimals present. Ive been working with the SQL statement and CAST functions and ive had no luck. All I get is whole numbers with no decimals. I've resorted to VBA and I am still getting the same results. every result is whole numbers. I would prefer 5 (FIVE) decimal places. </p>
  
  <p>such as 100.00000 and not "100".</p>
  
  <p>I've tried the split function in VBA and re assembling the 2 strings into a number with the decimal present and still no luck. </p>
  
  <p>The code below pulls in whole numbers only - I need decimal places!! thank you</p>
  
  <pre><code>Function numChange(input1 As String) As Integer
  
  Dim output As Integer
  
  If input1 = "" Then
  input1 = 0
  End If
  
  output = Format(input1, Number)
  
  numChange = output
  
  End Function
  </code></pre>