Function that converts an expression into a Single (Number.)
Syntax CSng (expression)
Single precision values have only 7 significant digits of precision. Floating-point number types should not be used for storing currency values.
Single can be used to store values from -3402823E38 to -1.401298E-45 or from 1.401298E-45 to 3.402823E38.
Dim sngDemo as Single
sngDemo = CSng(64.1234)
“People have a peculiar pleasure in making converts, that is, in causing others to enjoy what they enjoy, thus finding their own likeness represented and reflected back to them” ~ Johann Wolfgang von Goethe
CBool - Convert to boolean
CByte - Convert to byte
CCur - Convert to currency (number)
CDate - Convert to Date
CDec - Convert to Decimal (number)
CInt - Convert to Integer (number)
CLng - Convert to Long (number)
Number Data Types
Convert to Base 36
Nz - Detect a NULL value or Zero Length string.