From the course: Excel Formulas and Functions Quick Tips

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Format numbers and dates with TEXT

Format numbers and dates with TEXT - Microsoft Excel Tutorial

From the course: Excel Formulas and Functions Quick Tips

Start my 1-month free trial Buy for my team

Format numbers and dates with TEXT

“

- [Instructor] The TEXT function allows you to reformat numbers and dates as text as a specific way of using codes. These codes can be found on the Home ribbon tab. Click General, More Number Formats, and then Custom. You can view all the formatting options here. A common problem when importing addresses in the United States is that Excel will often remove the first leading zero. We'll use text to put it back. I'll start with =TEXT, open parentheses. The value is the contents of cell E2. I'll put in a comma, and now I need five characters, so I'm going to tell Excel with quotes to fill in the missing characters with zero. I'll close the quotes and parentheses, and I get my value that I can then fill down. Let's look at a more complex example. This time I'm going to use the pound sign as a number placeholder. I'll start with a text string. I'll use an ampersand to join the text, and now I'll put in my value. I first need to compute the sales bonus. I'll put in my comma and format it…

Contents