Fix problem where formulas display rather than their results, when this option has not been selected.
Every now and then a formula displays rather than the result of the formula. I realize there is an option for this; however; on occasion it happens to a particular cell or range of cells when this option has not been selected. The rest of the worksheet functions properly. This has been an ongoing problem for years.1 vote
Hi, This happens when a cell is formatted as Text prior to entering a formula. Since formatting a cell as text is an explicit operation, Excel doesn’t “automatically change that formatting” when you enter a formula.
You could bring back the pathway on the tool bar to creat new work books. YOU TOOK THAT OFF AND IT MAKES IT VERY DIFFICULT.
wE WERE ABLE TO CLIK ONTO NEW WORK ON LEFT SIDE OF TOOL BAR AND IT COPIED AND MADE NEW WORK BOOK INSTANTLY2 votes
This is already supported by customizing the QAT and adding the “Document Location” control to it.
To do that:
1. File > Options > Quick Access Toolbar
2. In “Choose commands from” select “All commands”
3. Find the “Document Location” command and add it to the QAT by clicking the “Add >>” button.
Hope that helps,
- Don't see your idea?