View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Static Date and Time code problem

Hi, Laura-
Will you please post your code? If you're capturing the system time
and date and writing that value to a cell, it may be just a matter of
formatting the cell to show both date and time. For instance:

Dim Datestamp as Date
Datestamp = Now()
Range("A1").value = Datestamp

In this example, if cell A1 is formatted properly, it will show both
time and date.