ctrl-;
(control-semicolon)
gives the date.

ctrl-shift-; (or ctrl-:)
(control-colon)
gives the time

paul wrote:

ctrl and : gives you todays date and stays that date
otherwise a liitle macro that copies today() and then pastes as a value
--
paul

remove nospam for email addy!

"-emma-" wrote:


Thanks for this but it only leaves me what I have already.:( I saved
while it was showing 14/07/2006...waited til past 12 midnight and when
I went back in it was displying 15/07/2006. I need to to stay on the
same date I made the selection in A1.

Any other ideas please?

Thanks,

Emma x

Ardus Petus Wrote:
ToolsOptionsCalculation check Iteration
enter in A2:
=IF(A1="N",NA(),IF(ISNUMBER(A2),A2,TODAY()))

HTH
--
AP

"-emma-" a écrit
dans
le message de news:
...

Hey,

This should be easy but I have been struggling with it for a while
now.

A1 = A Validation List with the options "Y" or "N".
A2 = The date (dd/mm/yyyy) appears ONLY "Y" was imput in A1. When
"N"
selected in A1, "N/A" apprears in A2.

Once A2 has been filled it needs to stay the same date and not
change
to the current date (Which what I have had to stick with for the
time
being :() I have battled with =NOW() and =TODAY() but all auto
update
each day which isnt what im after.

The N/A is unimportant...all that
really matters is the "Y" activating todays date and staying that
days
date.

Mail me for screen shots or futher information if needed.

Any help offered at all would be a great help!

Thanks,

Emma x


--
-emma-

------------------------------------------------------------------------
-emma-'s Profile:
http://www.excelforum.com/member.php...o&userid=36378
View this thread:
http://www.excelforum.com/showthread...hreadid=561653



--
-emma-
------------------------------------------------------------------------
-emma-'s Profile: http://www.excelforum.com/member.php...o&userid=36378
View this thread: http://www.excelforum.com/showthread...hreadid=561653



--

Dave Peterson