"Deb" wrote:

I am downloading a file from our company's database. It is no problem
formatting the standard military time to "regular" time, but I have to
double-click each cell to make the change. This takes an inordinate amount
of time because of the number of cells. Any way to make this go faster.
Thanks in advance!
how about double clicking the first cell then using format painter to copy
the format down the full column