Search results

  1. B

    Split String Question

    I get strings of text like this: 1.1-2.1-3.1 Im looping thru a string of numbers and rounding the numbers up to a full number That bit works ok How can I put the result back togeather like this: 2-3-4 Here is what I have so far: Dim myString As String Dim Result As String Dim MyArr As...
  2. B

    VBA FormatNumber

    RLAmount = FormatNumber((CDbl(Nz(txtPurPrice)) * CDbl(Nz(txtRLFeePercent)) / 100), 2) Debug.Print "RLAmount = " & RLAmount Result: RLAmount = 10 Im trying to get this to return a result of 10.00
Back
Top Bottom