In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are no numbers or values stored as text. In this video, I'll demonstrate five methods to quickly find numbers stored as text. Numbers as text usually happens when you pull data from another data source into Excel.
I'm going to follow up on this video, with a video on how to convert the text to numbers.
Chapters
00:00 Introduction
00:45 Method 1 Green triangle
01:09 Method 2 Use Status Bar
03:49 Method 3 ISNUMBER function
04:33 Method 4 ISTEXT
04:48 Method 5 Conditional Formatting
06:12 Bonus Tip Value Function
06:53 Closing remarks
Blog post by Chris Menard
[ Ссылка ]
What is the green triangle in Excel?
****
A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Trace Error Button image button appears. Click the arrow next to the button for a list of options.
This video came from a question asked by a Professional MBA (PMBA) student from the University of Georgia Terry College of Business. Web page for MBA students [ Ссылка ]
Status Bar in Excel
***
The Status Bar shows at the bottom of Excel. It reads Ready in the left corner and has your Zoom, for example 120%, in the right corner. Several features turned on by default in the Status Bar - Sum, Average, and Count.
If you select two numbers, you can right-click the word Sum (or any of the words) and turn on other features. I recommend you turn on Numerical Count, Maximum, and Minimum. They will show up for this worksheet, the workbook you are working in, and all future workbooks
Numerical count is the COUNT function - the total number of numbers you have (it is not counting text). Count is working as the COUNTA function. It is counting text and numbers. With both turned on, you know if you have text mixed with your numbers or values. See the screenshot below.
#msexcel #chrismenardtraining #microsoftexcel #microsoft365 #uga #pmba #mba #mbastudetns
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
