Search results

  1. B

    Split String Question

    This code works prefect, also gets rid of the "-" at the beginning of the results I cant think of anything to improve, works juts how i wanted Thanks
  2. B

    Split String Question

    I had noticed that and was getting around to figuring it out but you have beaten me to it
  3. B

    Split String Question

    What i need is all not even numbers round up 1.0 = 1 2.1 = 3 3.1 = 4 Etc
  4. B

    Split String Question

    No i dont want 1.0 to be rounded up Actually i had not tested full numbers yet I notice it rounds up all full numbers to the next digit
  5. 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...
  6. 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