Converting Numbers to Text

To convert a number to a text value, you can use the NumberToText function or the string concatenation, e.g., "" & x.

To avoid confusion, using NumberToText is usually the better option. See NumberToText for information on that. The second method is described here.

Examples

"" & (2^10) → '1024'

"" & Pi → '3.142'

"" & Exp(10) → '22.03K'

The coercion uses the number format for the object that contains the expression being evaluated. So, to use a different number format for the coercion, you must set the number format for that object. When you set the number format while viewing a table for the variable, be sure that no cells are selected, because cell-level formats (formats that apply to only part of the table) do not influence the coercion to text.

See Also

• string concatenation
• Coerce function parameter qualifier
• Numbers
• Numbers and text
• NumberToText
• ParseNumber
• ParseDate
• Number Format Dialog
• User-Defined Functions
• Math functions
• Text functions
• Multiple formats in one table