Use Special Data Formats for Numbers on Mac
Edited by Djinu, Alexander Avdeev, Eng
You're watching VisiHow. In this video, we are going to show some of the special data formats in Numbers on the Mac.
We are going to make an order form for one of our clients.
The order is "Widgets" and the price was $10.
We click the cell tab and then the data format drop-down menu.
We add a quantity to the "Quantity" column by clicking "Stepper".
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".
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.
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.
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.
For the "State" column, we can click "Pop-Up Menu".
The pop-up menu will allow us to add different items.
We are going to clear all of the items by clicking the minus button.
We'll add in some states that are nearby by clicking the plus icon.
Let's add "Georgia", "Florida", and "Alabama".
Now, when we click on a cell in the "State" column, we can easily select the state for the item.
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!
Video: Use Special Data Formats for Numbers on Mac
Recent edits by: Alexander Avdeev, Djinu