You can override the source format for the field in the Excel report. You will have to deselect the default option of "Keep Source Formats" for the field, and then you can apply Excel or custom formatting to ensure it does not come in as text.
The issue is that your source data loaded into Qlikview is in TEXT format.
If you use 'send to excel' inside the QVW, you will notice that the columns still indicate text fields in your excel output.
The solution is to modify your load script to update/convert the source data text fields to number fields.
Here is one of several community articles which discusses this text to num conversion process.
Once your source data is converted to numeric format using the load script in the QVW, then you should no longer show number as text fields in your 'send to excel' or your NPrinting excel report output.
As Frank mentioned, one way is to explicitly define field as numeric. E.g., Num(CtrlNo) as NCtrlNo
Another option is to change the Number format settings on the Number tab in Document Properties to Integer
Attached is a project that shows an example of both. Please extract to C:\Temp\MS folder or you will need to change the paths used in the NSQ.
HTH - Daniel.
Example.zip 140.5 K
You need to specify the format of the Expressions in Number tab or by using Num(), and in Dimensions you have to use Num(DimensionName, '###0') as calculated dimension in the front end or you can also do the same in the back end load script like below
Num(Column1, '###0') AS Column1,
Hope this helps you.