trim function ????

[Skywalker]

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.

[a_jam_sandwich]

Trim return the varible with spaces removed try

 

Dim trimmedText = Trim("     sdkhsdhkfhsd    ")
Msgbox(trimmedText)

 

Andy

[Skywalker]

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?

[zy_abc]

Dim dblX As Double
dblX = 10.444444444999998
dblX = CDbl(Format(dblX, "#.##"))
MsgBox(dblX)

 

Hope this helps.

[Skywalker]

Ok thx, this worked out just perfect :D

Thenk you for helping me out :D