Taking a custom number format to text?

[jeanchile]

Hello all, I have a spreadsheet that I have calculated some numbers and have the cell formatted to # ??/??. Using the MROUND function on the cell I take a number like this 0.4375 and convert it to a fraction like using =MROUND (A1, 1/16). This gives me 7/16 instead of 0.4375. I use this to get my "measurements" to look like the fractions of an inch on a tape measure.

My question is: How can I concatenate this number together with another one and have it display properly still (e.g. take cell A1 which is 7/16 and cell B1 which is 1/2 and combine them with other text to get: 7/16" to 1/2").

Thank you for your help with this.

[daddylonglegs]

Try using TEXT function, something like this

=TEXT(A1,"??/??''")&" to "&TEXT(B1,"??/??''")