Thanks for the tip guys I had not a clue you could do that. I tried it and it worked. I'm impressed. I'll have to use that from now on. so here's the question. If I don't copy and paste the formula after I've done it, does that mean that when I put the today function in there that it will change to tomorrow's date or something? I guess I don't really understand why you have to copy and paste. Gigi
Sent from my iPhone > On Mar 12, 2014, at 3:15 PM, Tim Kilburn <kilbur...@gmail.com> wrote: > > Hi, > > Probably the easiest thing to do would be to use either the =today or =now > function like you've mentioned, but after entering the formula, press cmd-c > to copy the cell, then cmd-shift-v to paste the formula results back into > that same cell. Rather awkward but only takes two steps and you're done. > the third step is a quick eMail to Apple giving them some numbers feedback > saying that we want that feature put back into Numbers. It's rather silly > for it to have been dropped in the first place. > > Later... > > Tim Kilburn > Fort McMurray, AB Canada > >> On Mar 12, 2014, at 4:11 AM, Nicholas Parsons >> <mr.nicholas.pars...@gmail.com> wrote: >> >> HI list, >> >> I'm trying to work out whether there are any shortcuts to enter the current >> date and time in a cell in Numbers. The functions =TODAY() and =NOW() are no >> good as these update in realtime. I want to enter the current date and time >> and to have this remain fixed. On iOS it's really easy, as the number pad >> has buttons for today and now. However, in Mavericks it isn't so obvious. >> >> On the Apple Support Forums I read some threads with apple script and >> automator actions, but I'm not comfortable enough with these to be able to >> implement them myself. >> >> Does anyone have any ideas? >> >> Thanks, >> Nic >> >> -- >> 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 macvisionaries+unsubscr...@googlegroups.com. >> To post to this group, send email to macvisionaries@googlegroups.com. >> 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 macvisionaries+unsubscr...@googlegroups.com. > To post to this group, send email to macvisionaries@googlegroups.com. > 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 macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
