#1 you need to either enter the time using Ctrl-;, and Ctrl-Shift-:, or use
VBA.

#2 - select a cell without the NOW function already populated.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jack Black" wrote in message
...
#1 I want to enter the (NOW) function in A1 and next to it enter a
number. (a diabetes blood sugar measurement)

I want to do this every day with tomorrws date being in A2 and the
number in B2. My problem is that each day A1 changes to the current
NOW........how do I get it to show yesterdays date?

#2. I have been (mis) using the NOW function for a few days, now
everytime I hit the functions button that's the only function I can
get. How can I tell it that I also want to use other functions as
well?

Thanks