suriya6in
04-08-2003, 08:02 AM
hi
i have a coloumn full of date with different formats.
One will be like 01.04.2003(1st april 2003)
the other will be 01/04/2003
next willbe 01-04-2003
these dates are DD/MM/YY in original.
But when i format this column to a particular format like
1st april 2003, it is either converting it as mm/dd/yy format or nothing is happening
is there any addin or excel tool to format it in dd/mm/yy format?
i have a coloumn full of date with different formats.
One will be like 01.04.2003(1st april 2003)
the other will be 01/04/2003
next willbe 01-04-2003
these dates are DD/MM/YY in original.
But when i format this column to a particular format like
1st april 2003, it is either converting it as mm/dd/yy format or nothing is happening
is there any addin or excel tool to format it in dd/mm/yy format?