Thread: Entering static Date/Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GAMOSTEVE GAMOSTEVE is offline
external usenet poster
  
Posts: 1
Default Entering static Date/Time

I'm trying to enter a date and a time in a worksheet if there is dat
entered into a particular cell. Example - Cell A contains data or nul
- if data, enter current date in Cell B and current time in cell C.

Problem I keep running into, the date/time updates to current with dat
entry into the next row.

Anyone have any ideas

--
GAMOSTEV
-----------------------------------------------------------------------
GAMOSTEVE's Profile: http://www.excelforum.com/member.php...fo&userid=1476
View this thread: http://www.excelforum.com/showthread.php?threadid=26384

Reply With QuoteReply With Quote