thanks for the replies.

I am already given this information as I have described, it will not be worth re-entering x-xx.x as xx:xx:xx and x.x to 0:x.x by hand for 100s of bits of data, I was hoping there was someway to 'convert' it - I eventually worked out I could select the column with x-xx.x and use the 'replace' tool to replace - for : ? That seems to work ok

But does anyone know an easy way I can convert x.x seconds eg 3.4 in a cell to 0:3.4 ? I really just need to get a 0: entered in front of each bit of data in a coloumn?

Sorry to be a pain but if this could get worked out it would be great!

If not it sounds like I need to find another supplier of the data with it entered in a better format?

Thanks