Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Convert Numbers to Text in Excel

By default, numbers are right-aligned and text is left-aligned in Excel.

This example teaches you how to convert numbers to ‘text strings that represent numbers’.

1. Select the range A1:A4 and change the number format  to Text.

2. Precede a number by an apostrophe and it will also be treated as text.

Also See:   Pad week numbers with zeros in Excel

3a. If you add text to a number and still want to format this number, use the TEXT function. Without using the TEXT function this would be the result.

3b. With the TEXT function.

Note: #,## is used to add comma’s to large numbers.

3c. Here’s another example. Apply a percentage format.

Note: use 0 to display the nearest integer value. Use 0.0 for one decimal place. Use 0.00 for two decimal places, etc.

Also See:   Advanced Number Formats in Excel

3d. And another example. Format a date.

Note: use less/more m’s, d’s and y’s to change the appearance of the date.

Leave a Reply

Your email address will not be published. Required fields are marked *