In FM 11
I have a text field which at present is formatted "As Entered" and I wanted to re-format it as General however at the bottom of the inspector it reads "No options available".
Why is this?
"General" is a number data format. What change in format do you expect to see if you selected "General" for your field?
There are no data formatting options for text fields, but you can find some for changing fonts, styles and text color on the appearance tab.
When they are exported in a csv file they show up with scientific formating. I'm trying to avoid this.
IF you have numbers in the field, change the field's data type to number instead of text.
I don't think the formatting is the problem. Are you sure they aren't simply being converted into scientific format upon import into Excel, for example? For instance if you import 15-digit Bar Codes into Excel they will often display like that.
Retrieving data ...