Excel Forum
Similar Content
Use Formatted Dates and Numbers within Other Text in Excel
Tutorial: How to put dynamic formatted dates and numbers into text in Excel. This allows you to hav...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Format Cells as a Fraction in Excel Number Formatting
Macro: This free Excel macro will automatically format a selected cell or many selected cells in ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Highline Excel Class 27: Custom Number Format & TEXT function


See how to use Custom Number Format for Cells and the TEXT function:
1)Format cells
2)Format Formula input numbers to show a label with Custom Number Format
3)TEXT function used with Text formulas to create labels
4)TEXT function to create TRUE FALSE formulas to check whether criteria is met
5)Count number of dates in a data set that meet criteria (certain month)

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.