02-26-2009 8:46 AM
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
02-26-2009 8:50 AM
02-26-2009 9:09 AM
Thanks for your help Phani.I tried it.But it didn't work.
Edited by: Venkat R on Feb 26, 2009 10:09 AM
02-26-2009 9:12 AM
Hi,
Just extend the column length of excel by double clicking top right side of that column.
Regards,
Prashant
02-26-2009 9:18 AM
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
02-26-2009 10:03 AM
02-26-2009 10:03 AM