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.

Thank you for your help.

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%).

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

    2 years 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

    2 years ago

    Thank you, that is really helpful.

Comments Closed.