Try the below and format the cell to time format..

=--TEXT(A1,"00\:00")

If this post helps click Yes
---------------
Jacob Skaria


"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!