title: Exponentiation conversion
body: <p>I am using:</p>
  
  <pre><code>For t = 1 To ActiveProject.Tasks.Count
      With Tasks(t)
          ' DurSen is a Custom Field Name. It returns an application field Number (such as 188743770 for Number4)
          Projectfield = FieldNameToFieldConstant("DurSen")
          ' the SpearmanRankCorrelation function occasionally produces a result like -6.06060606060606E-03.
          .SetField (Projectfield), SpearmanRankCorrelation(ProjectDuration, TmpVec, NN)
      End With
  Next t
  </code></pre>
  
  <p>This is a number expressed as an exponent. Due to the presence of the <code>"E"</code> in the number, it fails the <code>Setfield</code> function. The <code>.Setfield</code>  places the calculated value into the field referenced by ProjectField for a specific task, (t) but fails when the calculated value contains an "E". </p>
  
  <p>Any ideas on avoiding this problem?</p>