When you put in the =today formula the cell is populated with the
current date. When you copy it actually copies both the formula and the
results of running that formula (the current date). When you paste it
usually pastes the formula again but if you "Paste Special" that tells
it to paste the result from the formula rather than the formula itself,
making the date a static bit of text.
CB
On 3/12/14 6:48 PM, Eugenia Firth wrote:
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 <[email protected]> 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 <[email protected]>
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 [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.
--
¯\_(ツ)_/¯
--
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.
