This Excel tutorial explains how to format the display of a cell's text in Excel 2011 for Mac such as numbers, dates, etc (with screenshots and step-by-step instructions).
Not the kind of behavior that occurs in Excel for Windows. How to Delete Cell and Range Contents in Excel for Mac. The trick is to remember that fn+Delete is really a keyboard shortcut to the Delete key on a Mac. Then the world rights itself and the planets align. Frustration abates. You designed your Excel spreadsheet so that you will be able to keep track of your products' prices and part numbers, and you applied the Text format to the Part Number column — yet every time.
See solution in other versions of Excel:
Question: How do I format how the text displays in a cell in Microsoft Excel 2011 for Mac?
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.