DIsplay leading zeroes in text fields
I want to display the result of a calculation where the number could be a decimal smaller than 1, i.e. with leading zero, followed by units of measurement (letters). I am not yet able to do this.
Let's say that I need 1 to 2 oz. of hops to make 20 gallons of beer. The person then wants to make 8 gallons total. I am trying to get the calculated field to display "0.4 to 0.8 oz."
I tried to make it with merge fields. However, the merge field takes the size of the field name in the layout and disrupts the organization of the other elements.
I tried making the calculated field produce a number: this does not display the " to " or the " oz."
I tried making the calculated field produce a text result: does not allow for leading zeros when I look at the inspector.
What are my options?