Hi Nic You know, it's real weird that your computer doesn't seem to always to do what mine does, I guess. I typed in the equals sign and then typed today into my date field on March 12. I just checked. It's still March 12 in there. The only thing is, it put 12 A.M. in there for the time, even though it wasn't 12 when I typed it in. For me that doesn't matter. I did discover, however, that if I pasted into another row the date from the 12th, it stayed the 12th instead of going to today's date.
Then I tried the now function although I haven't figured out what happens if I leave it there. The today function didn't have a formula in there, but the now function left a formula in there. For me, and it seems like you are doing more intricate things than I am, it looks like I can use the now function just great. If it doesn't work ok, then I guess I can use Tim's solution of copying and pasting. I think that's easier for some of us lazy folks like me. Sincerely, Gigi On Mar 15, 2014, at 1:23 AM, Nicholas Parsons <[email protected]> wrote: > Thanks for the replies and help! > > I decided to get adventurous and try the Apple Script solutions I read about > (more details below). But yes, it seems funny Apple would take this feature > out, but I'm sure it will work it's way back in. After all, iOS has an easy > way of entering today's date, so I'm sure the Mac will get it too. And Gigi, > yes, if you enter the today() function, tomorrow when you open the > spreadsheet it will show tomorrow's date. Cutting and pasting is one > solution, but apparently that can mess up the formatting applied to that > cell. You can, however, cut and paste and match style. > > Anyway, the solution I've settled upon is to create a service with Automator. > The service just runs the below Apple Script, and then I can set a keyboard > shortcut to activate the service. This is pretty much the same as what Tim > suggested, but can be achieved with one key press. You just drag "Run Apple > Script" from the actions library into the empty workflow area. I set the > Automator workflow to receive no input, and to work in Numbers only. > > Here's the Apple Script to be copied and pasted into the workflow: > on run > set date_ to ((current date) as string) > set the clipboard to the date_ > tell application "Numbers" > activate > tell application "System Events" > keystroke "v" using {shift down, option down, command down} > end tell > end tell > end run > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
