Secretary problem 😉
I always wonder why there is a calculator close to a computer. It's totally ridiculous especially if you have Excel on your computer 😉
But a secretary told me one day "I'm fed up to start a formula with ="
In fact, there is a way to do calculations without equal
- Go in the menu Files>Options>Advanced
- Scroll down until you reach the end of the options
- In the section Lotus compatibility setting, check transition formula entry.
What happen's now in Excel?
Now, when you perform a calculation, Excel will add for you the symbol equal and display the result of your calculation.
Important: this option is not permanent.
When you close Excel you have to reactivate this option if you want to avoid starting your calculation with equal.
This option is not applicable to all the worksheets of your workbook. In fact, you have to select the worksheet where you want to have this option activated.
08/01/2022 @ 15:17
Wow... I am a long time CPA and long ago made the trans from Lotus to Excel. This is literally the only thing that has driven me crazy about not being able to do... THANK YOU!!!
Frédéric LE GUEN
08/01/2022 @ 17:34
You're welcome 🙂