Enter a Fraction in a Cell
posted by Rob Johnson on Mar.29, 2009, under Tips
Microsoft Office Excel can display, and take data entry as, fractions as well as decimal numbers. To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333.
-
"The CornDog"
Rob Johnson
(520) 705-5388
rob@corndogcomputers.com
Remote Support
• Windows
• Mac