View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SF SF is offline
external usenet poster
 
Posts: 4
Default How to change to time format?

Thank!

SF

"Bob Phillips" wrote in message
...
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