Forum Discussion
How to create a custom format for number and text in the same cell?
Hello, I am trying to create a custom format for cells that contains both number and text as follows: 29558 (45.1%) 537 (9%) 3749 (5.3%) The cell always contains a number followed b...
short answer is no.
But a macro could be written to do it.
Where do these numbers come from? Why not have them in different cells? If you have them in different cells you could then use a cell formula to concatenate them into a single cell (but will be text, not numeric as Excel doesn't recognize any format like that).
But a macro could be written to do it.
Where do these numbers come from? Why not have them in different cells? If you have them in different cells you could then use a cell formula to concatenate them into a single cell (but will be text, not numeric as Excel doesn't recognize any format like that).