problem with decimal point ( , .)

[nicnat]

I use some strings in a formula.
These strings can be "19.23" or "19,23".
I need the numbers to use in my formula.
I can use val() or Cdbl() but i have the problem
val(19.23) -> 19,23
val(19,23) -> 19
Cdbl(19.23) -> 1923
Cdbl(19,23) -> 19,23
With a . i have to use val() and with a , i have to use
Cdbl().
Is there something that recognize both?

Thanks

[Jerry Grant]

Do a bit of validation before the conversion:

Sub ToNumber(strValue As String) As Double
   If IsNumeric(strValue) Then
       strValue = Replace(strValue, ",", vbNullString)
       ToNumber = CDbl(strValue)
   Else
       ToNumber = 0
   End If
End Sub

[nicnat]

Thanks for the reply but,with your program i lose the decimal point and i don't have to lose it, i want to keep it.
Perhaps i can use Replace(strValue, ".", ",").

[Jerry Grant]

I think you are using a comma(,) as a decimal and I am using a period(.). Whatever you are using in your country as a decimal, then it MUST be retained.

In the UK, the comma is used as a thousand separator (10,000.00) therefore can be omitted without any detrimental problems (10000.00)Ten Thousand. If I replace the period, then the number becomes (1000000) Million.

Hope all is now OK

[nicnat]

I am from Belgium and we use , as decimal point.
Sometimes it's a problem because on the keyboards
numbersection it's a point so we use sometimes a point.
So that's why i have different values
(23.32 and 23,32)