Excel Forum
Similar Content
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 situati...
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 Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...



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.