Hi everyone.
I have a simple formula that sums the total ammount of cells.
I would like the result to have a suffix, as for example the word "ITEMS"
if the result of a formula is for example 25, I'd like it to show 25 ITEMS or whatever the word I want, as Miles, Watts, or any other word or phrase I could choose.
Is there any way to do this?
thanks in advance.
MacBook Pro with Retina display, OS X Mavericks (10.9.1)
=SUM(thecellstosum)&" ITEMS"
This will, of course, change the value in the cell into text. It cannot be used in any other numeric formulas. If or when when custom formatting comes back to Numbers, you could do the same thing with a custom format and just the simple SUM.
=SUM(thecellstosum)&" ITEMS"
This will, of course, change the value in the cell into text. It cannot be used in any other numeric formulas. If or when when custom formatting comes back to Numbers, you could do the same thing with a custom format and just the simple SUM.
Thank you very much! this solved my question. thank you.
How to add a suffix to a number
