Resolved problem

[andrews]

I do not understand why
in a sub i have written

dim w as double
dim nm as string
nm = "5.2356"
w = cdbl(nm)

but i see in de debug that w = 5000 ?
what do i wrong ?
Thanks for any response

 

[jmcilhinney]

Firstly, please provide a descriptive title for all threads. Your title is as good as no title at all. Secondly, please don't post unformatted code snippets, as they are unnecessarily hard to read. This one's not a big deal but others may be worse, so just always format them to help us help you.

 

[jmcilhinney]

As for the issue, your current culture could change how the comma is interpreted but I don't see how that code could produce 5000 either way. Can you please provide a screenshot showing that code with a breakpoint immediately after and the contents of the Autos or Locals window?

 

[andrews]

As for the issue, your current culture could change how the comma is interpreted but I don't see how that code could produce 5000 either way. Can you please provide a screenshot showing that code with a breakpoint immediately after and the contents of the Autos or Locals window?

I used point and comma without result
for i = 1 with a comma i get 5 for nm = 5,000
the culture is belgian

see now the screenshot

 

[jmcilhinney]

You said in post #1 that nm was "5.2356" and that w was 5000 but the screenshot you provided shows that nm is "5.000" and doesn't show any value for w. It doesn't show a value for i either, so we can only guess which item/element of rijrecords is being set on the current iteration, but it looks like it's rijrecords(2), which has a value of 5000. Converting "5.000" to a Double will depend on what the current culture is. If the current culture uses a period as a decimal point then it will convert to 5 and if it uses a comma as a decimal point then it will convert to 5000. I don't know what Belgian uses so you'll have to check. I know French uses a comma as a decimal point so Belgian may be the same. Take a look at CultureInfo.CurentCulture.NumberFormat.NumberDecimalSeparator and .NumberGroupSeparator to see. I suspect that the former will be "," and the latter will be ".", in which case what you're seeing appears to be exactly what you would expect.

 

[andrews]

Good but what to say with that

 

[andrews]

Sorry, it's resolved.
I made a mistake, the comma is valid
Thank you for your valuable intervention