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?