SAP Knowledge Base Article - Preview

2425437 - Cell format issue in Excel after exporting from Fiori: Numbers are exported as texts


After exporting to an Excel spreadsheet from a Fiori Application the numbers are displayed as texts:

  • decimals are separated with dots (e.g. 100.5) while the separator was a comma in the Fiori Application,
  • before negative values an apostrophe (e.g. '-5) is inserted,
  • amounts in that format cannot be used in formulas.



  • SAP Gateway
  • Fiori Applications
  • Microsoft Excel


SAP Gateway all versions


$format=xlsx, format, xlsx, excel export, cell format, string, number, decimals, decimals 5, fixed decimals, negative, amount, dot, coma, separator, sign, currency, p_decimals = 5, Should be enough for most scenarios, decimal point, 5 decimals , KBA , OPU-BSE-SDE , SAP Data Enablement , OPU-GW-COR , Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.