4 Replies Latest reply: Feb 7, 2014 5:34 PM by SGIII
Roseville Bob Level 1 Level 1 (0 points)

I can not find the INSERT DATE function to add a DATE to the footer of a NUMBER spreadsheet.  How do I do that? 


iMac, iOS 6.1.4
  • Barry Level 7 Level 7 (29,210 points)

    HI Bob,

     

    In Numbrs '09 InsertDate and Time is found in the Insert menu.

    Screen Shot 2014-02-07 at 5.05.56 PM.png

     

    Regards,

    Barry

  • YeOldMacFan Level 3 Level 3 (730 points)

    In Numbers 3.x you can place the current date in a footer cell by entering the formula =NOW().  It will always show the current date and can be formatted with your preferred date style.

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    Bob,

     

    Insert > Date didn't make the cut for the Version 3 edition.

     

    SG, a frequent poster here, has written a nice script that is a great substitute. Check back and I'm sure he will have visited and posted his solution.

     

    Jerry

  • SGIII Level 5 Level 5 (5,590 points)

    Bob,

     

    Further to Jerry's pointer, see this thread for a description of how you can set up an 'insert date' pick in your menu.

     

    Screen Shot 2014-01-11 at 6.18.51 PM.png

     

     

    If you want (thanks to Badunit for showing that this was possible) instead of going through the steps described there you can just grab a copy of the service via this link (automatic download from Dropbox).  When you doubleclick it, you'll be asked if you want to install it. You may have to go to System Preferences > Security & Privacy to click 'open anyway' if you get a warning message.

     

    That's it. After it's installed it will be a menu pick similar to the screenshot above.

     

    If you want to rename it, then in Finder hold down the option key choose Go in the menu, navigate to Library > Services and rename it there as you would any other file.

     

    If you don't like going to the Services menu then assign a keyboard to it at System Preferences > Keyboard > Shortcuts.

     

    Screen Shot 2014-01-11 at 5.50.40 PM.png

     

    SG