Thread: How to display text & fractions, referencing another cell?

I'm trying to simplify a conversion process, and am having trouble incorporating text and maintaing formating.

I have numbers formatted as fractions in a cell: 1/4, 1/2, 3/32, and so on. I want another cell to display the fraction and add text.

So if cell B2 is 1/4, I want cell A1 to state "Cell B2 is 1/4", but can only get it to state "Cell B2 is 0.25". If I format B2 as text, this works fine, but it throws off the math in critical formulas.

Is there some way to display a number as a fraction and have text in the same cell?

Thanks! Oh, I'm using Excel 2003 if that's of any use.

However,

for fractions like 3/32....


Nevermind! It works great all the way (just have to add the extra "?"'s for fractions with 2 or more digits.

Very helpful! Great job, as always! Thanks!

It worked for me too. THANK YOU!!

Originally Posted by stir-crazy

However,

for fractions like 3/32....


Nevermind! It works great all the way (just have to add the extra "?"'s for fractions with 2 or more digits.

Very helpful! Great job, as always! Thanks!