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.


Steps

  1. 1
    We are going to make an order form for one of our clients
    .
    The order is "Widgets" and the price was $10.
    Advertisement
    Was this step helpful? Yes | No| I need help
  2. 2
    We click the cell tab and then the data format drop-down menu
    .
    Advertisement
    Was this step helpful? Yes | No| I need help
  3. 3
    We add a quantity to the "Quantity" column by clicking "Stepper"
    .
    Was this step helpful? Yes | No| I need help
  4. 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. 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. 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. 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. 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. 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. 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. 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!

Video: Use Special Data Formats for Numbers on Mac

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Macintosh

Recent edits by: Alexander Avdeev, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 179 times.

x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No