Mike

in Row 2, just divide Row 3 by Row 4 (=A3/A4) and format the cell as a
"fraction"

Format | Cells | Number format | Fraction | up to two digits

You will get 1/8, 0, 1/16 and 1

Or, alternatively in Row 2, use the formula: =A3&"/"&A4

This will give you 1/8, 0/7, 1/16 and 3/3 but these will be text values, not
numbers.

Regards

Trevor


"burnsbyrne" wrote
in message ...

13% 0% 6% 100%: calculated from the 3rd and 4th rows
1/8 0/7 1/16 3/3: entered by operator
1 0 1 3: entered by operator
8 7 16 3: entered by operator

I have a spreadsheet with lots of cells like these. The top row
contains a formula that divides the numbers in the third and fourth
rows. The fraction in row 2 is entered by hand. The problem is that
the fraction is often not changed when updated numbers are entered.
The higher-ups who get this report have a very low tolerance for errors
made by other people. So, I am wondering if there is a way that I can
present the numbers in rows 3 & 4 as a fraction, still have them feed
the formula in row one, and get rid of row 2 altogether.

Any suggestions?

Mike


--
burnsbyrne


------------------------------------------------------------------------
burnsbyrne's Profile:
http://www.excelforum.com/member.php...o&userid=22153
View this thread: http://www.excelforum.com/showthread...hreadid=390289