How to change to time format?
 

How do I change a range of cell to time format (eg 17:30PM) through code?

SF

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

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