MacMost Q&A Forum • View All Forum QuestionsAsk a Question

# Is There a Function In Numbers That Is Does the Same As Text In Excel?

HI, In Excel there is the Text function converts a supplied numeric value into text, in a user-specified format.

I am trying to do the same in Numbers put there is not an equivalent function is there?

I am trying to bring the results of two separate calculation together into one cell, so far my best work around is to use an intermediary or hidden cell. I can do the two calculations separately then use something like = hiddencell1 & ” – ” & hiddencell2 which concatenates the cells retaining their specific formatting.

It works but is very clunky so I was wondering if there is a better way.

I am trying to display the results of two separate calculations into one cell for example in Excel I will often show the value and its percentage, for example 10(9%).
—–
Ian

### Comments: 2 Responses to “Is There a Function In Numbers That Is Does the Same As Text In Excel?”

2 months ago

You just do it exactly as you are now, but with calculations. For instance:

=(B2+C2)&" - "&(D2+E2)

This will give you "5 - 99" if the result of B2+C2 is 5 and D2+E2 is 99.

If you want C2 to show the value of B2 and the percentage of how much B2 is out of column B, then something like this:

=B2&" ("&ROUND(100×B2÷SUM(B),0)&"%)"

I'm multiplying by 100 and then using round to get values like 18 instead of .187573627

Ian
2 months ago

Thank you, that is really helpful.