In excel suppose I have 6Y,2M,3D &6Y,10M,10D &10Y,2M,9D in three different
cell.If I will perform sort on these data in ascending /descending order it
doesn't come properly ,but if I will insert one zero to the left of each
single digit figure it is coming properly i.e. 6Y,2M,3D becomes 06Y,02M,03D
and 6Y,10M,10D becomes 06Y,10M,10D . Hence I want to know how can I insert
zero to each single digit figure by using functions or any other way so that
my large data can be sorted automatically.Because If I will inser zero to
each figure including double digit/three digit then also there will be a
mess.

Thanx .