Excel Guides

Converting From Numbers to Text in Excel

You can convert numbers to text in Excel using the TEXT function. This function takes two arguments: the value to be converted and the format to use. The format is specified using a format code, which is enclosed in double quotes. For example, to convert the number 1234 to text using the format "0000", you would use the following formula:

=TEXT(1234,"0000")

The result would be "1234".

You can also use the TEXT function to convert dates and times to text. The format code for dates is "dd/mm/yyyy" and the format code for times is "hh:mm:ss". For example, to convert the date 12/31/2015 to text using the format "dd/mm/yyyy", you would use the following formula:

=TEXT(12/31/2015,"dd/mm/yyyy")

The result would be "31/12/2015".

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.