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