hello all
can any one put vba .i want when i hit the clear button dated cell E7 automatically select then i hit enter again cell H11 selected thenH12 & H13..respeatively I11,I12,I13...... till k13.
regrds
one more question...i want to write date without dashes & slashes..want to result like 12 Dec 2014..but there is no such format is working..from this format 00\/00\/00 result shown as 12/12/2014 but i want 12 dec 2014.there is any kind of formation is there..thnx
one more question...i want to write date without dashes & slashes..want to result like 12 Dec 2014..but there is no such format is working..from this format 00\/00\/00 result shown as 12/12/2014 but i want 12 dec 2014.there is any kind of formation is there..thnx
not working ....req format is only showing but result is not accurate..with this format if i put 121215 it is showing
15 Nov 2231
instead of 12 Dec 2015