Problem downloading to CSV

[Former Member]

Hi,

We have a report that is sent (Emailed)to the customer in Excel format.

The main problem with it is that there is a field in that report which is in character (CHAR 20) format.

If it has a value like this 501321E-00, when it gets downloaded to Excel it converts to 5.01E+05.

What do I have to convert that field(column) to text format.

Please help me to resolve this issue.Any help would be appreciated.

Thanks,

Venkat

Edited by: Venkat R on Feb 26, 2009 9:46 AM

[Former Member]

try using String format

[Former Member]

Thanks for your help Phani.I tried it.But it didn't work.

Edited by: Venkat R on Feb 26, 2009 10:09 AM

[former_member386202]

Hi,

Just extend the column length of excel by double clicking top right side of that column.

Regards,

Prashant

[Former Member]

Thanks for your reply Prashanth.I did try that it didn't work.When I double click on it,

it just shows 501321 and not 501321E-00.

Regards,

Venkat

[Former Member]

Could you please help me resolve this issue.

[Former Member]

Could you please help me resolve this issue.