I am concatenating a number of cells, including text and numbers. I have the original number displayed as a fraction e.g. 1 1/3. When I concatenate this, the result is 1.333333333333.
I have tried reformating the original cell, without luck. Is there any way to control this aspect of the concatenation?
Thanks in advance.
Tom.
I have tried reformating the original cell, without luck. Is there any way to control this aspect of the concatenation?
Thanks in advance.
Tom.