Thread: Change format of NOW()
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Change format of NOW()
Format(Now(), "m/d/yyyy hmm")

Suppose putting =Now() in an unformatted cell shows the imbedded
format. For me it is m/d/yyyy h:mm.

Hth,
Merjet



Reply With QuoteReply With Quote