By default, numbers are right aligned and letter text is left aligned in Excel. So in this article, I will show you how to convert numbers into words.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to convert Numbers to Letters in Excel
first. Select the area A1:A4 and change the number format to Text.
2. Add an apostrophe before the number and Excel will treat the cell as text.
3a. If you add text to a number and still want to format the number, use the TEXT function. If the TEXT function is not used, this will be the result.
3b. When using the TEXT function.
Note: #, ## are used to add commas to large numbers.
3c. Here is another example. Apply percentage format.
Note: use zero to display the nearest integer value. Use 0.0 for one decimal place. Use 0.00 for two decimal places,…
3d. And another example. Date format.
Note: Use less or more letters m, d, and y to change the appearance of dates.
In addition, you can also view many other excel articles here.