Here you will find how to export number values and have the cell show them as numbers and not text.
Use the javascript number function:
%{Number(${CUSTOM_FIELD})} |
Use JavaScript with Xporter for Jira Server link
Use JavaScript with Xporter for Jira Cloud link