How to Format Fractions to Percentages in Excel. The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages.

While Excel is smart enough to know you mean a fraction when you enter 2 2/3 , if you just enter just 2/3 , it defaults to the date format. To get around the problem, just enter a 0 in front of the ...

Left to its own devices, Excel will convert your fractions into dates as soon as you enter them in your spreadsheet. See how you can work around this problem.