Hello! I'm building a template to monitor my mothers blood sugar levels twice a day. Currently, I'm manually entering date and day of the week. Is there a way for me to format a column to automatically enter date and day of the week information or do I need to enter that cell by cell? I'm new to numbers'09 but learning. Thanks!
Hi Larry,
You can enter the Date using the Insert > Date and Time menu item, or by pressing shift-option-command-D.
If you also want the current time included in the entry, do the above, then double-click the cell to open the set date dialogue and choose the last format in the popup menu.
OR:
Enter the formula =TODAY() in all cells (after the last date you've entered) in the Date column. As each day arrives, select the cell(s) for that day, Copy, then Edit > Paste Values.
OR
If you're using a single row for each day's entries (ie. morning and afternoon levels recorded in separate columns):
Enter the starting date into a Header row. (example uses cell B1)
Enter the formula =B1+1 into B2 (row 2 is the first non-header row)
Fill the formula down to the rest of the cells in column B.
To add dates, drag the Row handle down to add rows. The formula will automatically fill into the new rows (IF every regular cell in the column contains the formula).
In any of these you can format the cells to show the date in a format that includes the weekday name.
Regards,
Barry
There are functions inserting the current date time but they insert a living date which will change all the time.
My preferred choice is the function "Insert Date Time" embedded in the free package WordServices from Devon Tech.
Yvan KOENIG (VALLAURIS, France) mardi 14 juin 2011 21:36:38
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
**,
I'm guessing you're correct, though I don't recall having done that. It's an awkward enough key combination that it's very likely an add-on. And it doesn't show up in the list or the user guide. Probably something I cobbled together to answer a similar question. Not a shortcut I use that often, though.
Regards,
Barry
Thanks for the suggestions. I've been shuttling between medical appointments for mom and dad the past couple days. I'll have a chance to play with recommendations when I land. For now, I'm doing the old manual stand by method for a few days until her appointment next week.
Cheers...Larry
Barry, I'm guessing shift-option-command-D is a shortcut you created. Insert Date & Time does not have a natural shortcut. I've never been able to get one to work consistently.
Thank you
Auto date for numbers
