Using the =NOW() Function

F

Fonz

When using =NOW() to have the sheet automatically enter the time and date,
anytime I make a change to the sheet, all the cells with the =NOW() function
update to the current time. Is there any way to get the date and time not to
update once it has appeared in it's assigned cell? Thanks in advance.
 
F

Fonz

This is the formula I currently have,

=IF(F2=0,"",NOW())

How is it supposed to look for what I mentioned below?
 
B

Bob Phillips

Use the keyboard, Ctrl-Shit-: (semi-colon)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

Dave Peterson

Ahem!

Shift

<vbg>

Bob said:
Use the keyboard, Ctrl-Shit-: (semi-colon)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
F

Fonz

The shift + control : only adds the time, I need the Time and date in one
cell, and ardus petus, I don't understand what it is specifically your step
is, I saw what you posted but don't understand, copy paste special - values,
I don't undertand what that means> COuld you explain a bit better please?
Thanks
 
M

Marcelo

the copy paste special - values, will replace the formula for the date that
you see on the cell.

Marcelo


"Fonz" escreveu:
 
F

Fonz

How is copy paste special - values used? Step ny step would help. Written
that way could be taken many ways. Thanks
 
M

Marcelo

Fonz,

click on the EDIT(menu) excel will open an various options one of than is
COPY, click on it. the cells will start winking.

click again on EDIT (menu) you will see an option PASTE SPECIAL click on it.

know excel will show you a window with any options the 3rd option of the 1st
column is values SELECTED IT click OK botton

hope this helps
Marcelo



"Fonz" escreveu:
 
D

Dave Peterson

ctrl-colon (spacebar) ctrl-semicolon


The shift + control : only adds the time, I need the Time and date in one
cell, and ardus petus, I don't understand what it is specifically your step
is, I saw what you posted but don't understand, copy paste special - values,
I don't undertand what that means> COuld you explain a bit better please?
Thanks
Click to expand...
 
A

Ardus Petus

Select your cell with formula =NOW'()
Hit Ctrl-C to copy it
Edit>Paste Special, check Values

Your cell will now contain the date and time as a (fixed) value, instead of
a (volatile) formula.

HTH
 
F

Fonz

I followed the special values steps the formula erased and the cell is blank.
What was it supposed to do? Sorry, I am having a hard time with this.
 
F

Fonz

I did the steps, now the date and time don't appear when the if statement is
met in my original formula which is : =IF(D2=0,"",NOW())

Seems as if the only way the date will appear in that cell is if I type it
in manulaly.
 
B

Bob Phillips

Hit Ctrl+colon :)) together, then hit the spacebar, and then
hit-Ctrl-Shift-; (semi-colon) togther, it will show datespacetime.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

Jay Somerset

Hit Ctrl+colon :)) together, then hit the spacebar, and then
hit-Ctrl-Shift-; (semi-colon) togther, it will show datespacetime.
Click to expand...

I think you have the shift key backwarDs on this. The semicolon is the
lower case character -- the colon is the upper case charater. If you use
the shift key, you get the colon.

Therefore, date = cntl-semicolon. Time = cntl-colon = cntl-shift-semicolon.
 
D

Dave Peterson

Yep. You're right.

Jay Somerset < said:
I think you have the shift key backwarDs on this. The semicolon is the
lower case character -- the colon is the upper case charater. If you use
the shift key, you get the colon.

Therefore, date = cntl-semicolon. Time = cntl-colon = cntl-shift-semicolon.
Click to expand...
 
Top