Convert numbers to text in Excel

By default, numbers are right-aligned and text is left-aligned. This example will teach you how to convert numbers to text strings represented by numbers.

1. Select a range of cells A1: A4 and give them a format Text (Text).
2. Numbers written with an apostrophe are treated by the program as text.
3. When you add a text string to a number and still want to preserve the number’s formatting, use the function TEXT (TEXT).
   • Without applying the function TEXT (TEXT) The result will be:
   • And using the function TEXT (TEXT):

Note: Code #,## used to add a comma in large numbers. In the localization of Excel, the comma must be replaced with a space.

Another example using percentage format:

Note: Use 0to display the nearest integer value. Use 0.0 to display a number with one decimal place. Use 0.00 for two decimal places, etc. In the localization of Excel, the dot must be replaced with a comma.

And one more example. Date formatting.

Note: Use less or more characters m (m), d (e) and y (d) to change the appearance of the date.