View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kbee kbee is offline
external usenet poster
 
Posts: 20
Default is it possible to set a cel to write the date and hour or date or

i need to add that , i need it to be formated in such a way that once u leave
the cell it will be locked and would not change if u return to it again at a
different time. Please write the syntax.
best regards

"kbee" wrote:

at the moment you enter the cell it will be formated to give the time of that
moment.
thanx for all the great answers.

bee