Article Edit Discuss

Use Special Data Formats for Numbers on Mac

Edited by Djinu, Alexander Avdeev, Eng

3 Parts:

Steps

Video: Use Special Data Formats for Numbers on Mac

Comments

You're watching VisiHow. In this video, we are going to show some of the special data formats in Numbers on the Mac.

Use Special Data Formats For Numbers On Mac.mp4-canvas52 801679.jpg

Steps

1
We are going to make an order form for one of our clients
.
The order is "Widgets" and the price was $10.

Was this step helpful? Yes | No| I need help
2
We click the cell tab and then the data format drop-down menu
.

Was this step helpful? Yes | No| I need help
3
We add a quantity to the "Quantity" column by clicking "Stepper"
.
Was this step helpful? Yes | No| I need help
4
We choose a number between a minimum and a maximum
.
Let's assume that the most that a client can order of this particular item will be 8. We press "Enter".

Was this step helpful? Yes | No| I need help
5
On the spreadsheet, we can change the number up to the maximum value down to the minimum value
.
It is 8 and 1 respectively in this example.
Was this step helpful? Yes | No| I need help
6
The "Shipped" column will either have "Yes" or "No"
.
We click "Checkbox". Once the item ships, we can click the checkbox to indicate that shipping has been done.

Was this step helpful? Yes | No| I need help
7
For the "Customer Feedback" column, we can click "Star Rating"
.
The star rating system will give a five-star grade. We can grade it according to what the customer said about the item.
Was this step helpful? Yes | No| I need help
8
For the "State" column, we can click "Pop-Up Menu"
.
The pop-up menu will allow us to add different items.

Was this step helpful? Yes | No| I need help
9
We are going to clear all of the items by clicking the minus button
.
Was this step helpful? Yes | No| I need help
10
We'll add in some states that are nearby by clicking the plus icon
.
Let's add "Georgia", "Florida", and "Alabama".
Was this step helpful? Yes | No| I need help
11
Now, when we click on a cell in the "State" column, we can easily select the state for the item
.
Was this step helpful? Yes | No| I need help

That was how to use some of the custom data formats in Numbers on the Mac. If you have any questions or comments, please leave them in the space below. Thank you for watching VisiHow!