I am using the Business Connectivity Services in SharePoint 2010 to display the content of a database table in an External List on my site.
One of the fields in the database table is of int type and so is mapped by BCS to an integer. As is standard for SharePoint the number is rendered on the display (and edit) forms using the thousands separator (i.e. "1234" is displayed as "1,234").
It is desired that this field be rendered without using the thousands separators but I cannot determine a way to get this to happen.
I would usually make a calculated field that returned the number as a string and use this on the display form, but as this is an external list I am unable to add new fields.
How can I have integer fields in external lists render without the thousands separator on display forms?