How to convert Sting value to double without rounding the values

faheem14 · March 28, 2023, 4:40pm

My String is: 98.98
If I convert this to Double it’s rounding it to 99. Is there a way to get the same number 98.98 after conversion to double?

Anil_G · March 28, 2023, 4:45pm

Did you use cdbl(“98.98”) only …it does keep it the same way

Cheers

faheem14 · March 28, 2023, 4:52pm

When I am converting it to an integer it rounds it to 99

Anil_G · March 28, 2023, 4:56pm

Obviously it will round…because integers dont have decimals…cdbl is to convert to double…integer are 1,2,3,-1 so on

If you want double use only cdbl

Cheers

faheem14 · March 28, 2023, 5:17pm

Got it Thanks