I have simple piece of text formatting that adds a degrees symbol to any value entered into a text field in a form (also the table).
This works fine - you type 0.3 and it becomes 0.3°
What I would like to do is have the ability to automatically add the degrees symbol to numbers only, and not for text. E.g: 0.3° or Hello (but not Hello°).
Can you put some kind IF statement or formatting rule inside the format properties box that can do this?
Thanks very much.
Code:
@°
This works fine - you type 0.3 and it becomes 0.3°
What I would like to do is have the ability to automatically add the degrees symbol to numbers only, and not for text. E.g: 0.3° or Hello (but not Hello°).
Can you put some kind IF statement or formatting rule inside the format properties box that can do this?
Thanks very much.