Hi there,

I have an access database with tables stored as lists on Sharepoint which is working fine, however I wish to change some of the columns number format which I cannot seem to find an option for when editing settings for each table/list on Sharepoint.

For example, a user can enter in numbers under a 'work order number' field as follows:

11111
22222

However this shows up in the table/list as:

11,111
22,222



If I had the tables stored locally I would go to design view and change the Format from 'Standard' to '#' to get rid of the comma, but this option isn't available in Sharepoint.

How do I solve this?