Single digit minutes displayed with a leading zero

I have imported from a csv file into excel a time in the format mm:ss.0. As long as both minutes and seconds are 2 digits the time is displayed as I want them to be e.g. 11:22.1.
But when the minutes are single digits such as 3:22.1 the display is 03:22.1. How can I stop excel putting in the leading zero?

I look forward to your suggestions

Thank you

Apply a Custom Format to those cells of:

m:ss.0

Hope this helps.

Pete

Pete,

Thanks for that I thought I would need mm to allow the time to go into double digits but tried with single and double and all ok.

Many thanks I close this now

Dave

I have applied the custom format to the cells involved but this is after the import so I know which cells need formatting. If I import another set of data I will not know which cells will be used so how can I do the formatting in the right place?
I used File...Import function, by using vba to import could the formatting be done as the data is imported? This is just one of a whole number of issues I am trying to tackle so not sure if to try and sort individually or try to tackle everything but I feel there is so much and complicated it would be quite difficult to explain.

Thanks

Do you mean that the next time you import the data the times might be in a different column, or that there may be more or fewer rows of them in the same column? If the times are in the same column then you could apply the custom formatting to the whole column, so it doesn't matter how much data you have. If the times might be in a different column then you would need some way of determining which column - do you have a header that could be used?

Hope this helps.

Pete

Thanks for that. I have now put together all my needs into a file explaining what I'm trying to do but not sure if I should send this just to you or raise a new post in the vba forum. Any advice appreciated.

Dave

Thank you for responding to this. As there is so much more involved I have opened a new post in the vba forum, this is the link to it http://www.excelforum.com/showthread.php?t=1137276

Dave