Home

How to Choose a Number Format in Your Numbers Spreadsheet

|
|  Updated:  
2016-03-27 14:23:01
|   From The Book:  
No items found.
AppleScript For Dummies
Explore Book
Buy On Amazon

Snow Leopard’s Numbers application offers plenty of formatting options for the data in your spreadsheet. After you enter data into a cell, row, or column, you may need to format it before it appears correctly. Number formatting determines how a cell displays a number. For example you might want data to appear as a dollar amount, a percentage, or a date.

Characters and formatting rules, such as decimal places, commas, and dollar and percentage notation, are included in number formatting. So if your spreadsheet contains units of currency, such as dollars, format it as such. Then all you need to do is type the numbers, and the currency formatting is applied automatically.

To specify a number format, follow these steps:

Click and drag your cursor over the cells, rows, or columns you want to format.

Click and drag your cursor over the cells, rows, or columns you want to format.

They appear selected.

Click the Inspector toolbar.

Click the Inspector toolbar.

The Inspector opens.

Click the Cell Format pop-up menu and click the type of formatting you want to apply.

You can format the data you’ve entered from the Inspector.

About This Article

This article is from the book: 

No items found.

About the book author:

Mark L. Chambers is a technical author, computer consultant, programmer, and hardware technician with over 30 years of experience. He has written over 30 computer books, including MacBook For Dummies, 9th Edition and Macs For Seniors For ­Dummies, 4th Edition.