Bug: Currency fields exported to Excel as text with U+202F thousands separator
Author: Tomasz311Created Sep 11, 2026Updated Sep 12, 2026
Please confirm that the bug report does not already exist
- I confirm there is no existing issue for this bug.
Steps to reproduce
Steps to reproduce
- Create a Currency field with the following settings:
- Currency Locale:
French (fr-sn) - Currency Code:
EUR - Precision:
1.00
- Currency Locale:
- Enter a value ≥ 1000 (e.g.
3116). - Download the view as Excel (.xlsx).
- Open the file in Microsoft Excel.
Actual behavior
- The value is exported as a formatted text string (
"3 116,00 €") instead of a numeric value. - The thousands separator is U+202F (NARROW NO-BREAK SPACE), which is what
Intl.NumberFormat('fr-sn')produces. Excel's formula bar does not render it properly and shows an unknown glyph:3□116,00 €. =UNICODE(MID(F2,2,1))returns8239(U+202F), confirming the character.- Since the cells are text, they cannot be used in formulas (
SUM, etc.), numeric sorting or pivot tables without manual cleanup.
Desired Behavior
Currency values should be exported as numeric cells (e.g. 3116) with an Excel number format matching the field configuration (e.g. #,##0.00 [$€-fr-sn] or #,##0.00 "€"). Excel then displays the value according to the user's regional settings, and the data stays usable for calculations.
At a minimum, if exporting as text is intentional, U+202F should be replaced by a regular space (U+0020) or a no-break space (U+00A0) for better compatibility.
Project Details
- NocoDB version:
<version> - Deployment:
<Docker / self-hosted / NocoDB Cloud> - Database: PostgreSQL
- Excel version: Microsoft 365
Attachments
No response
Source: nocodb/nocodb