View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Instead of NOW()

Ctrl/; then space then ctrl/:
that puts in the date & time as constants. If you only want the time, just
use ctrl/:

"kdsteff" wrote:

What function can be used in place of NOW() that won't keep changing the time?

Thank you