Export data to excel in text column

[#1]

Hi All,

I have a qvw file having 5 column. One column is Test having data like 123,324,ABC.....etc.

When I export it then in excel file Test column all the numeric data appears in right and string appears in left. I want all data should come on left only. Is there any macro function need to write or what is the solution.

Thanks,

Tej

9821791187

[#2]

Hi,

I think that's because you have aligned text and numbers in your qvw object in such way...

Change the alignments in chart and then try to export to excel...

Regards

[Anonymous]

HI singh.

you can change in exel file itself.

first select the column->chose the aligenment .