dear all

i want when i write 1106 in cell its should be show complete date like 11-jun-2016 if write 0106 its show date 01-jun-2016.after making this i will drag the date for more cells and also make link with this cell to others that should be works with it also..pl help

Gondal