In our H2 cell we have the cell formatted to fractions. Then in another cell we have a sentence created from multiple cells. Everything works but we can seem to get the fraction cell to just return the value. Example; If we have 1 it says “1 0/1” in the sentence if we have ¼ it says “0 ¼” in the sentence….we would like it to just display the same value we see in the H2. Below is our sentence…. See “TEXT(H2,"0 0/#0")”. Could anyone help.
="Please note: We Estimate that the air-conditioning equipment listed below will be shut down for a duration of " & TEXT(H2,"0 0/#0") & " " & TEXT(I2,"") & " between " & TEXT(H3,"dd-mmm-yyyy") & " to " & TEXT(H4,"dd-mmm-yyyy.")
R
CB
Bookmarks