Skywalker Posted June 4, 2003 Posted June 4, 2003 I want to trim the stuff that is in my variable, how do i do this? I tryed to do this, trim(variable) but it doesn't work. I would be please if somebody could help me with this one. Quote
a_jam_sandwich Posted June 4, 2003 Posted June 4, 2003 Trim return the varible with spaces removed try Dim trimmedText = Trim(" sdkhsdhkfhsd ") Msgbox(trimmedText) Andy Quote Code today gone tomorrow!
Skywalker Posted June 4, 2003 Author Posted June 4, 2003 Hmm ok that wasn't exactly what i ment :D I have a double with 9 decimals i want to breng it back to 2 example: from 10,44444444499999900111 to 10,44 How do i dou that? Quote
zy_abc Posted June 4, 2003 Posted June 4, 2003 Dim dblX As Double dblX = 10.444444444999998 dblX = CDbl(Format(dblX, "#.##")) MsgBox(dblX) Hope this helps. Quote Thanks & Regards, zy_abc
Skywalker Posted June 4, 2003 Author Posted June 4, 2003 Ok thx, this worked out just perfect :D Thenk you for helping me out :D Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.