Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting Strings to Floating Point Numbers
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00437418
Message ID:
00439240
Views:
15
You don't need the cSng(), and it also depends if your application is
dependent on rounding. In the case below, you would return 1.0, but in
the case of 1.999, you may want to return 2.0; so you would use
cInt(Round("1.999",0))

If you don't care about rounding, just skip the cSng and use cInt() to
chop off the floating portion.

>Ed,
>
>Thanks for the response. I was using the CSng() function in the code, but I wanted to have someone who knew what they were doing to confirm it.
>
>One more stupid question. Can I use the following combination of functions to convert the string containing the floating point number to an integer? If not, what should I use?
>
>CInt(CSng("111.111"))
>
>Thanks,
>
>Ben Holton
Previous
Reply
Map
View

Click here to load this message in the networking platform