Hello all,
I work with teachers, and some want to add fractions in Excel. While we understand how to format the cell to show a fraction, or fractions that are all halves, fourths, etc., is there anyway to get Excel to leave the fraction unchanged when entered? In other words, to NOT have the fraction change from 4/8 to 1/2 automatically, and without having to format individual cells. Teachers can work with many different denominators in one formula.
Any help would be appreciated. This one has me stumped!!!
I work with teachers, and some want to add fractions in Excel. While we understand how to format the cell to show a fraction, or fractions that are all halves, fourths, etc., is there anyway to get Excel to leave the fraction unchanged when entered? In other words, to NOT have the fraction change from 4/8 to 1/2 automatically, and without having to format individual cells. Teachers can work with many different denominators in one formula.
Any help would be appreciated. This one has me stumped!!!