I download a report in Excel 2007 format. The report has times listed as numbers with no colons. I need to convert the numbers into military time with a colon (600 to 6:00 or 06:00 and 1400 to 14:00). The times are listed in columns G:N and R:AR. Other columns contain text. I am very new to VBA and would like help.

Thanks,

BWP