Skip to main content
Question

How can I prevent thousand separator to end up in Excel export?

  • November 20, 2025
  • 1 reply
  • 6 views

In de U-GUI the data does not show a thousand separator for the integer value, as we have not used a numeric control for that column.

U-GUI value

 

Domain setting of specific column


When the data is exported to Excel it however does have the thousand separator set for the cell.

Excel export value


As this value is also used for external purposes by our users, it becomes quite a burden that they have to change the value as that dot (in my case) also ends up in their other program/tool, which is undesirable.

How can i prevent this behaviour from happening?

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • November 24, 2025

Hi Mark,

There is currently no way of forcing a text-string to be exported of a field with a numeric (int/tinyint etc.) datatype. To get the desired effect, you would have to store the numeric value as a varchar datatype.