String to number conversion, not simple (for me)

[PaulLag]

Hello there,

I'd need some help.

I need to convert a string to a number.
You would say that it is simple, and I can solve the problem using Csng.

Let me explain the issue:

the problem is that sometimes I have a string live this

a) 123.45 => csng gives me 12345
b) 67.8 => csng gives me 678

the final aim is to get

a) 123,45
b) 67,8

therefore I can't find an easy solution just dividing it by 10 or 100.
If dividing by 100 in case a is correct, in case b I would get a wrong number.

Please, can anybody help me ?

[antoka05]

You could try with:

CSng(Replace("123.45",".",","))

Regards,
Antonio

[snb]

Please Login or Register  to view this content.