CINT, CSTRING, CDOUBLE as Formulas
You can do it in VBA, can we just have it as a formula to avoid txt to number drama.
We have these already in Excel. They are:
You may also want to take advantage of ISNONTEXT and ISNUMBER as you use these.
Kenneth Barber commented
It should be pointed out that you need to use INT(VALUE()) to get the same effect as CINT().