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
Bookmarks