Hiya,
Hope someone knows this.
I want to combine values from two different cells and report them as a range in another cell. So in principle I know how to do this - assuming I want values from Cells D4 and H4, I do the following:
D4&"-"&H4
However, what I do not want is the millions of decimal places after each number. D4 and H4 are set to two decimal places, but using the above formula I end up with something like this
3.123456789 - 5.456789123
and I really only want 3.1 - 5.5
Is there a way of doing this?
Hope someone knows this.
I want to combine values from two different cells and report them as a range in another cell. So in principle I know how to do this - assuming I want values from Cells D4 and H4, I do the following:
D4&"-"&H4
However, what I do not want is the millions of decimal places after each number. D4 and H4 are set to two decimal places, but using the above formula I end up with something like this
3.123456789 - 5.456789123
and I really only want 3.1 - 5.5
Is there a way of doing this?