Trying to keep the 0 after a decimal place in a numeric field eg. 1.10 1.20 etc
Numeric fields automatically remove the 0 at the end of a numeral with a decimal place, so 1.10 will become 1.1 but I want it to stay as 1.10.
Forum Discussion
np
Edit the field properties and set the # of decimals to 2
Edit the field properties and set the # of decimals to 2
Similar question. I have it set where it pulls correctly to 2 decimal places on any forms or tables. However, when I try to pull a field into a mailto: it loses the formatting. I saw a previous post of yours recommending using round to solve the problem for cutting it down to 2 points. That solved that problem. Now the only issue is when there is a 1.1 as in above it is losing the 0 and I need it added back.