I have a large sheet with several columns that list date time like this

0820 (5/3)

I'd like to search the entire sheet and anytime a cell has a date with this format convert it to
05032010 :0820

Anyone have coding they can share with me?

Thanks
Steve