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