How do I make a the field '>24' into a num for excel export.

[luzu]

Hello,

I have a table with a field that is showing '>24' I need this to be a number format for when I export to excel. 

the formula is dual('>24',24)...how would i do this? 

[Alan_Slaughter]

Hi Luzu, this might be helpful:

To export a field with a custom number format like '>24' to Excel while maintaining the desired formatting, you need to apply a custom number format to the field in Qlik Sense before exporting. Here are the steps:

1. In the Qlik Sense app, locate the table or chart containing the field you want to export.
2. Right-click on the field and select "Number Formatting".
3. Change the "Number Formatting" option from "Auto" to "Custom".
4. Enter the desired number format pattern in the "Pattern" field, e.g. '>24'.
5. Click "Done" to apply the custom number format.

After applying the custom number format, when you export the data to Excel, the field should maintain the specified '>24' format.