Exporting excel number exporting as string

[FGRak]

Hi

Using Crystal Reports 2020, I have a formula that checks if a date field is less than the current date and if it is then return an field that is an amount. However, when I export to excel XLSX as data only it exports as a string. How can I get it to export as a number please?

I have formatted the field to number with 2 decimals places.

This is the formula

If {InvcHead.DueDate} < CurrentDate And {InvcHead.DueDate} >= CurrentDate - 30 Then ToNumber({InvcHead.InvoiceAmt})Else ToNumber(0)

Thanks

[radinator]

How do you know it is a number? Does Excel show the warning message the value is a string but appears to be a number?

[FGRak]

I have checked the database in the table, but actually its Decimal not number. Yes excel shows warning. Thank you

[FGRak · Accepted solution]

Managed to resolve the issue. The field was using the grouped field rather than the actual formula field. The export now is in number format.