Text field with numbers and or letters
I have a text field called P.O.# The reason it's a text field is that some P.O.'s we receive have a text prefix i.e. PR92828. Some are only numbers i.e. 63636. If I enter 63636 as the P.O. number a...
Forum Discussion
Another workaround option is to change the field to a numeric field.
Then it will give you the settings option to chose the comma usage. change it. save it. then change the field back to text.
If you already have data in there with letters. I'd recommend duplicating the field and testing, so you don't lose your data.
(Again, I've never had to do it this way, but sometimes changing the field type will carry over old attributes)
Then it will give you the settings option to chose the comma usage. change it. save it. then change the field back to text.
If you already have data in there with letters. I'd recommend duplicating the field and testing, so you don't lose your data.
(Again, I've never had to do it this way, but sometimes changing the field type will carry over old attributes)