Hello
I am sure there is a simple enough solution but...
I have a cell that has both text and number, and even though I have formatted the cell as 'Number' with 0 decimal places, it is not returning a rounded figure (obv due to the text component). Is there a solution for this?
E.g. =(G13-E13)/7 & " /"
This currently gives me a result of 0.714285714285714 /, when it should show a result of 1 /
Help!
Thank you in advance!
Bookmarks