View source for Converting Numbers to Text

[[Category:Styles and options]]

To convert a number to a text value, you can use the [[NumberToText]] function or the [[Text Concatenation Operator: &|string concatenation]], e.g., <code>"" & x</code>.

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

==Examples==

:<code>"" & (2^10) &rarr; '1024'</code>
:<code>"" & Pi &rarr; '3.142'</code>
:<code>"" & Exp(10) &rarr; '22.03K'</code>

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 ==

* [[Text Concatenation Operator: &|string concatenation]]
* [[Function_Parameter_Qualifiers#Coerce_.3Ctype.3E|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]]