5

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.

my insert menu

  • 1
    "Insert -> Date & Time" is now back as of at least version 4.3.1. Note that you need to double-click the cell to enable that functionality. It ignores any Data Format you have applied to the cell (meaning it won't follow any pattern you've established or data format you've applied, and defaults to it's own). The resulting entered data isn't even formatted as Date & Time, instead as Automatic. – George C May 1 '18 at 19:52
  • In 5.3, that feature is there, but greyed out. – Calion Jan 4 '19 at 20:53
  • As mentioned in my earlier comment, you have to double-click in the cell to activate the insertion point in order to enable the Insert -> Dat & Time menu item. – George C Sep 7 '19 at 14:24
7

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 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 enter image description here enter image description here

| improve this answer | |
  • 8
    While both of these methods will indeed work, note that they will auto-update themselves as opposed to entering a fixed date and time. – George C Feb 20 '15 at 18:19
  • 1
    To convert the formula to a fixed value (which won’t auto update), you can copy the cell and use Edit > Paste Formula Results. – duozmo Mar 19 '18 at 3:12
5

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.

| improve this answer | |
  • 4
    But it will also update it; so if you re-open the spreadsheet later on, it'll show the current time, not the time when you set it. – Matt Gibson Feb 24 '17 at 15:49
2

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.

| improve this answer | |
  • This appears to be true although Numbers has some sort of aggressive autocomplete that makes it pretty hard to avoid to entering NOW as a function – kuzzooroo Sep 18 '16 at 1:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .