How to convert content into number ?

[Sean J]

I have a new worry that I can not solve VMT.
I have this:
...
Case 6
Range ( "E8") = "159768.02": Range ( "E9") = "191.77": Range ( "E10") = "55,918.80" Range ( "E11") = "67.12 "
...

But what do I need for my values "159,768.02" ... are numbers in my table?
CDbl (...) I always use for my textbox, but here, as it is me who writes the values in advance, I do not know the correct syntax.

[Aleksandra]

It seems to me that you can use CDbl () here, but there may be a problem with point and the comma.
Try: Range ( "E8") = CDbl ( "159768.02") or Range ( "E8") = CDbl (159,768.02)

Or maybe it directly, by not putting quotation marks: Range ( "E8") = 159768.02

[Archibald]

Well you have a point and a comma in your number. E8 and E10 will never be numbers to Excel. Either you put a point or a comma. But not both.

So to add something to what was said by Aleksandra, if you really want to keep your syntax and comma Point you can do this:
Range ( "E8") = CDbl (Replace ( "159768.02 ",".",""))

Best regards

[Sean J]

it works thank you much ... but with the comma.
Problem solved, thank you much.