I want leann how put month and day on numberprogram

I want to lean how to put back month and day on number my budge

Posted on Aug 26, 2021 5:30 PM

Reply
2 replies

Aug 26, 2021 5:44 PM in response to rice88

Hello, Numbers user guide...

Format dates, currency, and more in Numbers on Mac - Apple Support


Format dates, currency, and more in Numbers on Mac

You can format a table cell with a specific data format (for example, number, currency, percentage) that determines how data in the cell appears, and how it’s used in calculations.

You can also choose how many decimal places appear in cells that contain numbers, currency units, or percentage values, even if the exact value entered in the cell has more decimal places than you want to show. The actual value entered is always the value used in calculations, regardless of how many decimal places appear in the cell. If a formula refers to text in a cell, the displayed value is used in the calculation.

You can change a cell’s format even if you already typed content in the cell. For example, if you have a table that shows your monthly budget, you can have a currency symbol (for example, a dollar sign $) added to all cells automatically by formatting the cells as currency, then selecting the symbol you want.


Numbers automatically interprets text strings that you type in a recognized date format as dates (for example, 6/10/17).

  1. Select the cells or table you want to format.
  2. In the Format  sidebar, click the Cell tab, then click the Data Format pop-up menu and choose Date & Time.
  3. Click the Date pop-up menu, then choose a format.
  4. If you choose None, no date is displayed in the cell, even if a date is entered and used in date and time calculations.
  5. Choose a format from the Time pop-up menu.
  6. If you choose None, no time is displayed in the cell, even if a time is entered and used in date and time calculations.

If you don’t enter both a date and a time, Numbers adds a default value for you. For example, if you type “1:15 PM,” Numbers adds today’s date by default.

The Smart Cell View at the bottom of the window shows you the actual value of both the date and the time for a selected cell, even if you choose to show only one in the table.

Durations (units of time)

You can also create custom cell formats to display other data, such as phone numbers. See Create a custom cell format in Numbers on Mac.


See also

Create a custom cell format in Numbers on Mac

Insert formulas and functions in Numbers on Mac



This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

I want leann how put month and day on numberprogram

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.