Thread: How to change to time format?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default How to change to time format?
Selection.Numberformat = "h:mm AM/PM"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SF" wrote in message
...
How do I change a range of cell to time format (eg 17:30PM) through code?

SF




Reply With QuoteReply With Quote