Hi
I uploaded attached excel file including dates.
While uploding I am using crosstable function in order to get tranpose value.(everything is ok )
However the date format occurs as text. I tried many functions (date, date#, date(date#), floor etc)
But I couldnt change the format. (pls see attached file)
Is it due to the crosstable function?
Is there any way to change the format text to date?
Thanks a lot.
