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.

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

Ad

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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas14 905766.jpg
    Advertisement
    Was this step helpful? Yes | No
  2. 2
    We click the cell tab and then the data format drop-down menu
    .
    Use Special Data Formats For Numbers On Mac.mp4-canvas17 83892.jpg
    Advertisement
    Was this step helpful? Yes | No
  3. 3
    We add a quantity to the "Quantity" column by clicking "Stepper"
    .
    Use Special Data Formats For Numbers On Mac.mp4-canvas23 343593.jpg
    Was this step helpful? Yes | No
  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".
    Use Special Data Formats For Numbers On Mac.mp4-canvas28 324619.jpg
    Was this step helpful? Yes | No
  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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas41 787021.jpg
    Was this step helpful? Yes | No
  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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas53 273997.jpg
    Was this step helpful? Yes | No
  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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas62 058787.jpg
    Was this step helpful? Yes | No
  8. 8
    For the "State" column, we can click "Pop-Up Menu"
    .
    The pop-up menu will allow us to add different items.
    Use Special Data Formats For Numbers On Mac.mp4-canvas75 118936.jpg
    Was this step helpful? Yes | No
  9. 9
    We are going to clear all of the items by clicking the minus button
    .
    Use Special Data Formats For Numbers On Mac.mp4-canvas82 214396.jpg
    Was this step helpful? Yes | No
  10. 10
    We'll add in some states that are nearby by clicking the plus icon
    .
    Let's add "Georgia", "Florida", and "Alabama".
    Use Special Data Formats For Numbers On Mac.mp4-canvas91 526818.jpg
    Was this step helpful? Yes | No
  11. 11
    Now, when we click on a cell in the "State" column, we can easily select the state for the item
    .
    Use Special Data Formats For Numbers On Mac.mp4-canvas104 959535.jpg
    Was this step helpful? Yes | No
    Advertisement

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 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.