Little Question

[momoelz]

For that little question I have to make a post lol anyways I am amateur in vb

but how do i convert 12354,58469
to 12354 ? without commas after it?

[BillyM]

You're not exactly clear on what you're asking to do.

12354,58469

You just want to grab the 12354 and completely forget about 58469 to leave yourself with 12354?

If that's what you're asking, this is one way to do it.  I'm assuming 12354,58469 is held in a string variable.  I'll name that variable "moelz".  I'll name the new string that holds 12354 as "newMoelz"

```
Dim num as integer
Dim moelz as string
Dim newMoelz as string

moelz = "12354,58469"

number = InStr(moelz, ",")
newMoelz= Left(newMoelz, num - 1)
```

newMoelz will now be "12354"

[Joyce]

```
number = InStr(moelz, ",")
```Should be
```
num = InStr(moelz, ",")
```You declared it as Num, and the line setting the new string value uses Num as well.
:)

[BillyM]

Woops.  Thanks Yami =)

[momoelz]

oki thx a lot in php it would be a lot simplier xD