I am using a RTF template for a report, the output of this report is in Excel.
The issue is that when the excel output is opened, the columns which are containing numbers have been formatted as "GENERAL". I have made the field to be number in the RTF template but it was of no use.
I need the columns to be formatted as "NUMBER", how can this be done ?
Look into the data type of the the column in the data source, if it is a character you can use the conversion function to convert the column value into a number and then you can have further formatting of the number in the rtf..