Could anyone help me to provide the format as below. You can use Macro, if you want to format, else if any other easy step, tell me. I searched other threads and all refer to specific cells, but I need dynamic code.
S No Column 1 Result 1 07-09-2012 0912 (First Two Digit Month and Next Two Digit Year) 2 12-10-2012 1012
The result column is the desired output of mine.
One thing is important. This row may be 10 or 20 or anything. If I give the Date in the cell, then the result column should display the format as given in the Date column.
Hope you understood my requirement. Kindly let me know if you have any clarification.