I am linking the field with numbers from +20.00 to -20.00. But when I open each number with a + sign in detail, the sign disappears. How can I make the + always appear before the number?
There is not a way to explicitly ALWAYS show the sign in a numeric field. If you MUST physically show the numeric sign then you would need to define the column as TEXT and use the DECIMAL() function to convert from text to numeric anywhere that value is used in a numeric equation.
I hope this helps!
I tried the following The OD Sph field has type text. 1. I write a value of +2.00, in details it shows me 2.00. 2. I give an option through Valid if to pull data from a column with values +2.00 or another number, Again in details it shows me without +.
I tried the OD Sph field to have Type enum, I added values, and again in details the + disappears.
With values with - I have no problem. example -2.00.