ActiveSheet.Columns(1).NumberFormat = "h:mm:ss;@"

--
Tim Williams
Palo Alto, CA


"Sean" wrote in message
...
The column is supposed to be time field as 15:30:25. But it currently
shows
as general like 0.646064815. How can I format the column to display as
time
in macro?

Thanks.