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

Question

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 &#038; &#8221; &#8211; &#8221; &#038; 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%). &#8212;&#8211; Ian

Accepted Answer

Thank you, that is really helpful.

Search MacMost By Tag or Keywords

Tag Search: “excel” (1 results)

Welcome to MacMost

Free Weekly Newsletter

MacMost Online Courses

Keyboard Shortcuts PDF

Connect with MacMost

MacMost Sections

Popular Tutorials

Information