Date-picker in Numbers 5.1

It is there but difficult to get to. It seems to only work in cells where you have used the menu item Insert/Date & Time.

1. Click in cell where you want a date
2. Go to the menu item Insert / Date & Time to insert today's date & time
3. Click on the date in the cell and a window will pop up that allows you to format the date. It also has the date picker. If you are editing a cell where you previously inserted a date, you will have to click a few times to get to the window to appear. One click to select the cell, another to select the date in the cell, and a third to get the window to appear.
4. Click on the date picker icon in the window to open the date picker.

You can use the date picker on cells where you used Insert Date & Time (or copy/pasted one) but apparently not on cells where you have typed a date yourself.

Hi Anthony,

Wayne found the solution in Date-picker in Numbers 4.0.5

"OK. so I finally found how to do this. Thanks for the screenshot.

The steps are:

1A) select the cell where you want the date picker

1B) pause, then click a second time OR

1) double click the destination cell

2) select the menu item "Insert > Date & Time"

3) single click the highlighted date in the cell

When the cell is not selected to get the date picker

1) double click the cell and, while the date is highlighted,

2) singled click the date

3) now single click the calendar at the bottom right"

************************

En francais:

D'ACCORD. donc j'ai finalement trouvé comment faire ça. Merci pour la capture d'écran.

Les étapes sont:

1A) sélectionnez la cellule où vous voulez le sélecteur de date

1B), puis cliquez une seconde fois OU

1) double-cliquez sur la cellule de destination

2) sélectionnez l'option de menu "Insérer> Date et heure"

3) cliquez une fois sur la date mise en surbrillance dans la cellule

Lorsque la cellule n'est pas sélectionnée pour obtenir le sélecteur de date

1) double-cliquez sur la cellule et, alors que la date est en surbrillance,

2) singled cliquez sur la date

3) maintenant cliquez sur le calendrier en bas à droite

Cordialement,

Ian.

***********************

Do not forget https://communities.apple.com/fr/community/iwork/numbers

Cordialement,

Ian.

Bonjour Anthony,

Single click in a cell

Un seul clic dans une cellule

Double click in a cell

Double-cliquez dans une cellule

Date and Time 😉.

Happy Numbering!

Des Numbers heureux!

Cordialement,

Ian.

One day I may understand this forum software, but I doubt it. I looked at that link and all I saw was the response that said "I found it". No other posts were there explaining what was found or how to use it. Now I go back and all the posts are there. I miss the forum software from a few years ago that actually worked right and was easy to use and easy to search. I quit posting for a long time because of their adoption of this messed up forum software that seems to be all about looks, not usefulness. Rant over.

Hi Badunit,

Rant all you want! There are many users who find glitches in this forum software.

But please do not take your expertise away. I always admire your insight to problems.

Regards,

Ian.