Suppose I have 6Y,3M in one cell 6Y,7M in another cell and 6Y,10M in another
cell.While I am sorting in descending order 6Y,10M shoul come first then
6Y,7M, then 6Y,3M should come. But in my case 6Y,10M comes last.But if I am
inserting one 0 my problem can be solved ,but without this how can it be
done.Or If I have to insert 0 , how this process be automated by using any
function.becauz I have lots of data , so 0 cann't be inseted manually.
Bookmarks