I've recentely upgraded to Excel 2016 (Office 365) and I have a small problem.
In my spreadsheet, I need to convert feet&inches to metric, so I have set my formula to convert feet to meters from an input cell.
However, in my input cell, when I type +188/12, the formula bar displays 15.6667 instead of =+188/12. The cell is allright, it displays 15.67' as I expect, but I want the formula bar to keep this fraction. not the result.
I tried elsewhere in my sheet where I have no custom cell format and I retain the formula, which is weird.
How do I correct this?
Bookmarks