Time format set from VBA
Thanks. I had checked in several places looking for just what you supplied
with no luck.
Mike
"Bernie Deitrick" wrote:
Mike
Range("BlahBlah").NumberFormat = "hh:mm"
Cells(lRow,ICol)NumberFormat = "hh:mm"
HTH,
Bernie
MS Excel MVP
"Mike" wrote in message
...
How do I go about setting the format of a cell to HH:MM from VBA?
I don't want the seconds showing. Just the Hour and Minutes. I have a
program that is collecting data and I need to fill one of the fields with the
time the data was taken. The worksheet is not setup ahead to pre-define the
cell formats. I need to format the cell as I'm putting the time into it.
Thanks for any help.
Mike
|