Hi,

I got two main problems when dealing with cell format:

1) I cannot set time format with fractions of second without including hours
(e.g. I cannot have a time like 27:43.12)

2) When I copy text from other sources (e.g. HTML) into excel, very often I get data in date for, so that , for example, "2-1" becomes February 1st.

Does anybody know if there is a solution for these issues?

I apologize if the answers were already posted: I've just registered to the forum and I didn't find the solution by seaching the past threads.

Thanks
Amblipo