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 doesnt 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 wasnt exactly what i ment

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
Thenk you for helping me out