Тёмный

Excel Showing Formula instead of Results - Quick Fix! 

TrumpExcel
Подписаться 375 тыс.
Просмотров 3,6 тыс.
50% 1

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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

Опубликовано:

 

7 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@trumpexcel
@trumpexcel 5 месяцев назад
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
@nadermounir8228 5 месяцев назад
Thanks Trump for this nice video 📹 👍
@IvanCortinas_ES
@IvanCortinas_ES 5 месяцев назад
Great explanation. Thank you Sumit.
@trumpexcel
@trumpexcel 5 месяцев назад
Thanks Iván 🙂
@seenu99250
@seenu99250 5 месяцев назад
Interesting and informative thank you
@trumpexcel
@trumpexcel 5 месяцев назад
Glad you found it helpful 🙂
@mdhashmath9353
@mdhashmath9353 3 месяца назад
Superb
@playwithexcel7357
@playwithexcel7357 4 месяца назад
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?
@canirmalchoudhary8173
@canirmalchoudhary8173 4 месяца назад
Such things especially happens with Dates.
@user-en7dz7gu2v
@user-en7dz7gu2v 5 месяцев назад
👍
@anthonylott835
@anthonylott835 4 месяца назад
*Promo SM* 😏
Далее
5 Clever Name Box Tricks in Excel 🤯
14:27
Просмотров 11 тыс.
Склеил девушку-курьера ❤️
01:00
Say Goodbye to IF Statements in Excel with SWITCH
7:45