z3phyr84

I've attempted this all day today and have been unable to get anywhere, except through a long, tedius macro that does one excel box at a time. Here's the situation and what I need to do: I have data that gets exported into a table format, which I copy and paste into Excel. The data can ONLY be exported in the following example format: :06:08 :07:08 1:06:35 :06:30 Each of these are representing minutes and seconds related to my project. Now, in Excel, the formulas don't work properly unless a '0' is entered before the first semi-colon, like this: 0:06:08 0:07:08 1:06:35 0:06:30 I need to have it highlight and copy the table (yeah, easy) and then have it add a 0 in front of any semi colon that does *not* have a digit preceding it. Eg: Add 0 in front of :06:08 but not in front of 1:06:35 I can't simply replace every case of ':' with '0:' because that would make it look like: 0:060:06, and it ruins a lot of my formulas. And, I can't figure out how to get it to recognize that 0:, 1:, 2:, 3:, 4:, 5:, 6:, 7:, 8:, and 9: are different than just : with nothing in preceding it. Any possible solutions or direction would be much appreciated!