Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1814-1815.xlsx
Learn how to remove all formatting, but leave the content in an Excel Worksheet.
Topics:
1. (00:00) Introduction
2. (00:05) Why Remove Formats?
3. (00:18) Apply Normal Style
4. (00:31) Clear Formats
5. (00:38) Keyboard shortcut #1
6. (00:56) Keyboard shortcut #2
7. (01:04) Keyboard shortcut #3
8. (01:24) Find and Fix “Numbers Stored As Text” Data Error
9. (01:45) Keyboard to convert Text Numbers back to Numbers
10. (01:49) Closing, Video Links

#shorts

https://excelisfun.net/files/12-M365ExcelClass.pdf

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunSun, January 22, 2023 2:37pm