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.

Copy
Paste Special - Values

HTH
--
AP

"Fonz" a écrit dans le message de news:
...
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.

This is the formula I currently have,

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

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

"Ardus Petus" wrote:

Copy
Paste Special - Values

HTH
--
AP

"Fonz" a écrit dans le message de news:
...
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.

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

"Fonz" a écrit dans le message de news:
...
This is the formula I currently have,

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

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

"Ardus Petus" wrote:

Copy
Paste Special - Values

HTH
--
AP

"Fonz" a écrit dans le message de news:
...
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.

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

Ahem!

Shift

<vbg

Bob Phillips wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

--

Dave Peterson

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

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

Marcelo


"Fonz" escreveu:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

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

"Marcelo" wrote:

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

Marcelo


"Fonz" escreveu:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

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:

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

"Marcelo" wrote:

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

Marcelo


"Fonz" escreveu:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

ctrl-colon (spacebar) ctrl-semicolon



Fonz wrote:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.




--

Dave Peterson

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.

"Dave Peterson" wrote:

ctrl-colon (spacebar) ctrl-semicolon



Fonz wrote:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.




--

Dave Peterson

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)

"Fonz" wrote in message
...
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.

"Dave Peterson" wrote:

ctrl-colon (spacebar) ctrl-semicolon



Fonz wrote:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.




--

Dave Peterson

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

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

HTH
--
AP


"Fonz" a écrit dans le message de news:
...
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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

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.



"Ardus Petus" wrote:

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

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

HTH
--
AP


"Fonz" a écrit dans le message de news:
...
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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.

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

Fonz wrote:

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.

"Ardus Petus" wrote:

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

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

HTH
--
AP


"Fonz" a écrit dans le message de news:
...
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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Fonz" wrote in message
...
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.







--

Dave Peterson