Insert date & time in latest version of Numbers

Question

I've looked around online and have found references to an "Insert => Date & Time" capability in Numbers for OSX. But it's not there in my version of Numbers (3.0.1 -- 1483). Has this capability been removed?

I've pasted a screenshot of my Insert menu below.

Don Gardner · Answer

When you "double click on the cell" in Numbers v.10.1 "Insert date and time" is no longer greyed out!

Edward Brey · Answer

Type the formula =NOW, copy it to the clipboard, and paste the formula results. It's not exactly a hotkey, but it is mouseless and works "out of the box".
=NOW, Enter, Up, Command-C, Shift-Command-V

Carl · Answer

According to Apple (http://help.apple.com/functions/mac/5.0/), you'll need to enter "=NOW()".  Not having used Numbers very much, I didn't know you had to enter the () after the word.

wolfsweat · Answer

Just happened upon this thread looking for an answer to the same question. What I have discovered is to type "= Now." This will give you the current date and time at that moment.

chrisjr · Answer

Unfortunately, Apple removed that option in the menu bar. However, you can still get the today's date by manually typing it (obviously) or by selecting the cell and typing "=Today", followed by the return key.

enter image description here

You can also type "=Date", followed by the return key. You can then manually select the date there.

enter image description here

You can also type "=Date", followed by the return key. You can then manually select the date there.

Insert date & time in latest version of Numbers

5 Answers

Add your own answers!

Ask a Question