totn Excel 2016 Basics

MS Excel 2016: Format display of text in cell (ie: numbers, dates, etc)

This Excel tutorial explains how to format the display of a cell's text in Excel 2016 such as numbers, dates, etc (with screenshots and step-by-step instructions).

Question: How do I format how the text displays in a cell in Microsoft Excel 2016?

Answer: Select the cells that you wish to format.

Microsoft Excel

Right-click and then select "Format Cells" from the popup menu.

Microsoft Excel

When the Format Cells window appears, select the Number tab. In the Category listbox, select your format. A sample of your text will appear on the right portion of the window based on the format that you've selected. Click the OK button when you are done.

Microsoft Excel

In this example, we've chosen to format the content of the cells as a currency number with 2 decimal places.

Microsoft Excel