Excel Showing Formula instead of Results - Quick Fix!

If your Excel file is showing the formulas instead of the values (formula results), this video will cover a few things you can do to fix this.
In this video, I will show you three easy ways to fix the issue when Excel shows the formula instead of the result:
0:00 Intro
00:18 Turn Off Show Formula Setting
01:29 Remove Apostrophe/Space before the Formula
02:13 Change the Cell Format
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course

[@nadermounir8228]

Thanks Trump for this nice video 📹 👍

[@seenu99250]

Interesting and informative thank you

[@trumpexcel]

Glad you found it helpful 🙂

[@IvanCortinas_ES]

Great explanation. Thank you Sumit.

[@trumpexcel]

Thanks Iván 🙂

[@canirmalchoudhary8173]

Such things especially happens with Dates.

[@mdhashmath9353]

Superb

[@playwithexcel7357]

Sir please make a video on following
1. How to remove all the content of table without removing column name with a shortcut key?
2. When data is big and we apply filters on data and formula on other side and when we want to confirm if the formula we applied gives same result with filter data, sometimes the result area gets hidden.
Is there anyway that we can keep intact result area applying filter simultanrously?

[@user-en7dz7gu2v]

👍

[@anthonylott835]

*Promo SM* 😏