Fractions
Posted by Mick on June 14, 2001 4:13 AM
Does anyone how you can display 1/1000000 as a fraction. I keep trying using the special format option, but get (0/1) all the time. I am going to use the number in a formulae. Much appreciated if anyone could help.
Cheers
Posted by Joe Was on June 14, 2001 6:15 AM
In Excel 2000 the menu clicks are:
Format - Cells - Number - Fraction - then use a option like "Up to one digit (1/4). If you need 1/1,000,000 I am not sure you can get it. I did not check this but I think it does up to three places? JSW
Posted by John on June 14, 2001 8:05 AM
For help try http://www.geocities.com/davemcritchie/excel/excel.htm
Lots of formatting info there, including fractions.
