Enter layout mode.
Without anything selected on your layout, go to the data formatting tab and specify "as entered" for number data formatting.
This should reset the default data format for this layout.
Note that it's very easy for format settings to mysteriously "stick" as default settings when using versions of FileMaker older than FileMaker 12.
Can you enter layout editting mode in table view? I'm not really sure what you're referring to, I assumed you were referring to the inspector? The values are displayed correctly in form and list view just not in table view and I don't know how to change it. Some values are in my table view but not used on the actual layout... those are the ones that I can't change the display for.
Can you enter layout editting mode in table view?
Yes. You can enter layout mode on any layout regardless of whether you are in Form, List or Table view, provided that you are a full access user.
When you add a field to your Table View that is not physically present on the layout, the default data formatting settings from the inspector are applied. What I am describing will alter the default settings to "as entered".
In some cases, you have to put the field on the layout and specify a data format for it in order to get a format that is different from the default setting. Say you add two fields to Table View and one needs to be formatted "as entered" and another needs to be formatted as currency. In that case, you have to place at least one of the two fields on your layout in order to get different data formats for each.