![]() Note: You can use the CInt or CLng function to convert a string to an integer or long (respectively) data types. The following code uses the CLng function to convert a string to an integer: MsgBox CLng("13.5") The following code will convert a string to an integer: MsgBox CInt("7.55") 5 the function will round down, if the fraction is greater than or equal to. You can use the CInt or CLng function to convert a string to an integer. In this tutorial, we are going to go over the functions that you need to use to convert a string to an integer, long, double, decimal or currency data type ( Click here to learn about converting numbers to strings) Convert String to Integer ![]() You may be required to convert numbers stored as text to actual numbers in your VBA code.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |