Hi,

I am facing an issue with report output in Excel format.

I have a column in database which is of type VARCHAR and when the value for that column
is coming with a '+' sign in front, all the numeric data after that value is displayed in text format

For eg: if the column value is 'WebFOCUS', then there is no issue, all the numeric values are
displayed as numeric itself. But if the value is '+WebFOCUS' then all the numeric values in the
report are coming in text format due to which i am not able to get the sum of the numeric values.

Consider the following example

SNO DATA
-------------------
1 INFORMATION
2 BUILDERS
3 +WEBFOCUS
4 DEVELOPER
5 STUDIO
6 FEX


Here, as the value for DATA is +WEBFOCUS, the numeric values 4,5 and 6 are coming in text format


I am using output format EXL97. Please help me out in rectifying this issue.

This message has been edited. Last edited by: Kerry,

You might want to extract the first character of that field into a separate field using EDIT MASK and then EDIT again to make it an integer. Then print two columns, one of which you can add up.