Question : vba string to integer
Answered by : vastemonde
MsgBox CInt("7,55") ' Integer -> 8
MsgBox CLng("7,55") ' Long -> 8
MsgBox CDbl("7,55") ' Double -> 7,55
Source : | Last Update : Fri, 12 Feb 21
Question : vba string to number
Answered by : aw-jeez
CInt("7.55") '8
CLng("13.5") '14
CDbl("12.34") '12.34
CDec("12.34") '12.34
Source : https://www.automateexcel.com/vba/convert-text-string-to-number/ | Last Update : Mon, 24 Oct 22