Using the =NOW() Function

[Guest]

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.

 

[Ardus Petus]

Copy
Paste Special - Values

HTH

 

[Guest]

This is the formula I currently have,

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

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

 

[Ardus Petus]

My suggestion suppresses the formula and replaces it with current value.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Dave Peterson]

Ahem!

Shift

<vbg>

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

--
HTH

Bob Phillips

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

 

[Guest]

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

 

[Guest]

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

Marcelo


"Fonz" escreveu:

 

[Guest]

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

 

[Guest]

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:

 

[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

 

[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

 

[Guest]

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.

 

[Guest]

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.

 

[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)

 

[Dave Peterson]

Or use a macro to plop in the date/time.

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

 

[Jay Somerset]

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

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.

 

[Dave Peterson]

Yep. You're right.

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.