Use Special Data Formats for Numbers on Mac

Edited by Djinu, Alexander Avdeev, Eng, Anonymous

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 | I need help

  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 | I need help

  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 | 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".
    Use Special Data Formats For Numbers On Mac.mp4-canvas28 324619.jpg
    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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas41 787021.jpg
    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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas53 273997.jpg
    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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas62 058787.jpg
    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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas75 118936.jpg
    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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas82 214396.jpg
    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".
    Use Special Data Formats For Numbers On Mac.mp4-canvas91 526818.jpg
    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.
    Use Special Data Formats For Numbers On Mac.mp4-canvas104 959535.jpg
    Was this step helpful? Yes | No | I need help

    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

Comments

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




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,600 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Use Special Data Formats for Numbers on Mac"?
 

Article Info

Categories : Macintosh

Recent edits by: Eng, Alexander Avdeev, Djinu

Share this Article:

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

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

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