Promotic
WikipediaLinkedInYoutubeTwitterFacebook

CSng - function of language VBScript

Description:
Returns an expression that has been converted to type Single.
Syntax:
CSng(expression As Variant) As Single
Calling:
n = CSng(expression)
Parameters:
expression(Variant) Any valid expression.
Note:

The conversion functions can be used e.g. if you want some operation result to be expressed as a particular data type (rather than the default data type). For example, use CDbl or CSng to force double-precision or single-precision arithmetic in cases where integer arithmetic normally would occur.

Use the CSng function to provide internationally aware conversions from any other data type to a Single type. For example, different decimal separators and thousands separators are properly recognized depending on the locale setting of your system.

If expression lies outside the acceptable Range for the Single type, an error occurs.

 
Caution: This function can convert only values with separators set locally (e.g. value 3.14 or 3,14). Therefore a problem arises when values in the text form originate on another computer with different setting. That's why it is recommended the Pm.CSng method that solves this problem!
Example:
Dim nDouble1, nDouble2, nSingle1, nSingle2
nDouble1 = 75.3421115: nDouble2 = 75.3421555
nSingle1 = CSng(nDouble1) 'nSingle1 contains 75.34211
nSingle2 = CSng(nDouble2) 'nSingle2 contains 75.34216
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice