I have a straight table which has both number and percentage values in single column, how do i export them into a excel with the same format and not text format?

[pipuindia99]

I have a straight table which has both number and percentage values in single column, how do i export them into a excel with the same format and not text format?

[settu_periasamy]

Hi Prabhu,

How do we understand that column type is % or Number data?

do you have any separator to identify the format? If we write the Number and % in the Excel it will give the text format only..

[Anonymous]

IN  EXCEL TO CHANGE THE EXCAL FORMA TO CHANGE IT THAN  MAY  BE YOU GET

[pipuindia99]

I want to export from QlikView to Excel, i have a column where I have numbers and percentage.

[pipuindia99]

I think you have misunderstood my question, I want to export from QlikView to Excel directly in the same format