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.
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.
ActiveSheet.Columns(1).NumberFormat = "h:mm:ss;@"
--
Tim Williams
Palo Alto, CA
"Sean" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
ActiveCell.Numberformat = "hh:mm:ss"
or if you will be showing hours more than 24
ActiveCell.Numberformat = "[hh]:mm:ss"
--
Regards,
Tom Ogilvy
"Sean" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
Thanks, Tim & Tom. It works.
"Tom Ogilvy" wrote:
> ActiveCell.Numberformat = "hh:mm:ss"
>
>
> or if you will be showing hours more than 24
>
> ActiveCell.Numberformat = "[hh]:mm:ss"
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Sean" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks