View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default Dates-Automatically entered in cells

Taryn

Tap Control and Semi colon for date
Tap Shift and control and Semi colon for time

Mike Rogers

"Taryn" wrote:

Hi,

Is there a function to automatically enter the current, real-time date in a
cell? I'm looking for a function similar to what is used in the header and
footer section of a workbook that allows the footer to be customized and to
insert on a page the date. The function,if this is the correct term to use,
shows up as &[Date] in the footer or header. Is there something that I can
set-up maybe a macro, in a designated column to automatically be displayed
in a cell?
-- Thanks
TBJohnson