One way to change data format to a column with varchar as datatype is to use String functions in a measure in obiee Admin tool and then use it in report.
But I need to change data format directly in report. How can I do it in obiee 11g in 'Column Properties' -> 'Data Format'? or is there any other way to do it in report?