Is there a way to stop percentage from converting in a formula?
I have two columns Value and Units that individuals are filling out. Some rows will have percentages for the Value and others will have numbers. I have third column Current Value that combines Value and Units, but when someone enters a percentage
Example:
- Value = 15.25%
- Unit = "women in Group A"
- Current Value Formula
= [Value]@row + " " + [Unit]@row
- The formula converts that to ".1525 women in Group A".
- What I want it to convert to "15.25% women in Group A"