Skip navigation

How to automatically put in date when data is entered into a specific cell?

216 Views 2 Replies Latest reply: Mar 31, 2013 6:54 PM by Barry RSS
todd1010 Level 1 Level 1 (0 points)
Currently Being Moderated
Mar 31, 2013 2:19 PM

I'm trying to find a way to automatically input the current date in a cell when data is entered?





More questions:



1) I created a custom template but is there a way to have it remember previous text I've entered from previous fill out templates?

  • Wayne Contello Level 6 Level 6 (12,625 points)

    There is no Timestamp feature in numbers.  You can insert the current date and time by selecting the menu item "Insert > Date & Time"


    You can also make a cell in a convenient location in your document contain the function "=now()".  You can copy this cell, then paste value into a destination cell anytime you need the current date and time.


    I do not understand the concept of making a tamplet that contains specific data... that sounds like a document which you update.  The reason for a template is to store a collection of tables, graphics, and calculations without data.

  • Barry Level 7 Level 7 (29,095 points)

    Wayne is correct regarding inserting the current time and date, but it's not quite that simple.


    Insert >  Date and Time initially inserts the current date with the time set to 00:00:00 (midnight at the beginning of that day), and the cell (assuming it's format is set to Automatic) displays only the Date part.


    To update the entry to include the current time, you need to immediately (ie. before leaving the cell) double click the cell to view the options. Click the popup menu, and choose the bottom item.


    You can also set a keyboard shortcut to insert Date and Time, but this acts the same as choosing the menu item—you'll still have to reach for the mouse to include the current time.






More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.