You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have a cell in Numbers which displays a value generated by a simple formula (A2 x .25).
How can I edit the formula to add text before and after the value?
Example: I want to add the letter X in front of 0.09375 followed by a space and F5 so it reads:
X0.09375 F5
This should do it:
The formula calculates the value. The concatenation operators (&) join the "X" prefix, the formula result, and the " F5" suffix into a single text string.
When entering the formula, use an asterisk ( * ) in place of the multiplication sign. Numbers will automatically replace the * with the multiplication sigh, but will not recognize that sign (or a lower case letter x) that is typed into the formula directly.
Regards,
Barry
This should do it:
The formula calculates the value. The concatenation operators (&) join the "X" prefix, the formula result, and the " F5" suffix into a single text string.
When entering the formula, use an asterisk ( * ) in place of the multiplication sign. Numbers will automatically replace the * with the multiplication sigh, but will not recognize that sign (or a lower case letter x) that is typed into the formula directly.
Regards,
Barry
Thanks Barry! That worked perfectly.
Chris
Adding text to a value in Numbers
