put a fraction in one cell and want the adjacent cell to automatically show the percentage
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | 13/17 | Excel will interpret cell A1 as General format. | ||
2 | 0.764705882 | If you start with the = sign to indicate a formula you will get 0.764705882 formatted as General. | ||
3 | 76.47% | Cell A3 contains the same formula as cell A2, but is formatted as Percentage with two decimal places. | ||
Sheet1 |