Recent content by bigshop

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

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

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

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

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...

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