Numbers and Strings
Numbers can be written as integers, decimal numbers, in scientific notation with an E preceding the power of ten, and as date-time values. A single period by itself is the missing numeric value.
For example, these are all numbers:
. 1 12 1.234 3E3 0.314159265E+1 1E-20
One or more characters placed within double quotation marks constitute a string. For example, these are all strings:
"Green" "Hello,\NWorld!" "54"
Notice that if a number is in quotation marks, it is a string, not a number. There are two functions you can use to change a number into a string or a string into a number.
Use Num() to convert a string into a number. For example:
Num() cannot convert non-numeric characters, so it produces a missing ...