Spreadsheet 123 Excel 2007: Format display of text

Also learn how to format the display of text in a cell in Excel 2003/XP/2000/97.

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

Answer:  Select the cells that you wish to format.

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

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.

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