I am working with an Excel file. I was trying to record a macro that would change the format of a range of cells, but it replaced the data that was in the cells with the test that I had recorded. I have searched through the Help files for the answer, but haven't found anything that works.
I need the data that is formatted as "0000" to be reformatted as "hh:mm".
I would apprieciate any help getting me on the right track.

Brent