Excel Query

Check it will work.... Subodh(Pune)

you can also try this formula

this will convert the text in Date format as per excel, which will be easy you use,

like if you want to write

10609

and you want to show it as

1-Jun-2009

this will remain in exact date format as per excel, which is easy to sort / filter later on if required.

suppose your 10609  is in A1

formula is

=DATEVALUE(LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2))

it will be converted into Date Value

39995

now you can change date format to see date in any desired format.

Thanks

& Best Regards

Praveen