Excel - 5 easy ways to identify numbers stored as text

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
https://chrismenardtraining.com/post/...

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 https://chrismenardtraining.com/uga-e...

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 – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!