Chapter 121: Using the TEXT Function to Format Numbers

Home / Chapter 121: Using the TEXT Function to Format Numbers

Course Content
Advance Excel
Advance Excel
0/132
Chapter 1. Accessing Ribbon Commands With The Keyboard
00:00
Chapter 2. Activating And Deactivating Interface Options
00:00
Chapter 3. Adding Comments To Formulas
00:00
Chapter 4. Adding Formulas To Text Boxes
Chapter 5. Adding Hyperlinks To Excel Objects
Chapter 6. Controlling Pages On Printing
Chapter 7. Controlling The Quantity Of Worksheets
Chapter 8: Create a Chart with a Single Key
Chapter 9. Create Your Own Fill Handle Lists
Chapter 12: Creating and Using Custom Views
Chapter 13: Excel Keyboard Shortcuts (Ctrl Shortcuts)
Chapter 14: Customize the Ribbon and Quick Access Toolbar
Chapter 15: Displaying File Path, File Name, and Sheet Name
Chapter 17: Drilling Down into Pivot Table Data
Chapter 18: Flash Fill in Action – Completing Data Columns
Chapter 21: Managing Cells With Large Text Content
Chapter 23: Multiple Sheet Data Entry and Sheet Management
Chapter 25: Recommended Pivot Tables
Chapter 29: Summarizing Data Using a Sparkline
Chapter 30: Table Styles of Your Own
Chapter 32: Time Difference and Duration Particularly Over 24 Hours
Chapter 34: Use Watch to Keep an Eye on a Cell Value
Chapter 37: 3D Referencing
Chapter 38: Absolute Cell Referencing Explained
Chapter 43: Adding Subtotals to a Worksheet of Data
Chapter 49: Clearing Cell Contents vs. Clearing Cell Formatting in Microsoft Excel
Chapter 50: Controlling Most Print Settings in One Place
Chapter 53: Copying Formulas and Functions in Microsoft Excel
Chapter 52: Copying Formulas and Functions
Chapter 58: Creating Headers and Footers
Chapter 71: Finding and Replacing Formats
Chapter 72: Fixing On-Screen Rows and Columns
Chapter 76: Formatting Graphical Objects
Chapter 80: Hiding and Unhiding Columns and Rows
Chapter 88: Managing the Conditional Formatting Rules
Chapter 99: Other Mathematical Functions in Microsoft Excel
Chapter 106: Running the Spell Checker
Chapter 110: Sorting Data in Microsoft Excel
Chapter 115: The Pie Chart in Detail
Chapter 116: The Stacking Order
Chapter 119: Using RANK to Calculate Placings
Chapter 126: Using Print Titles and Print Areas
Chapter 127: Using SmartArt Graphics
00:00
Chapter 130: Using the Page Break and the Page Layout Views
Chapter 10: Creating Excel Tables
Chapter 16: Displaying Formulas Instead of Results
Chapter 27: Removing Duplicate Values in Excel
Chapter 39: Activating and Deactivating Worksheet Protection
Chapter 40: Adding a Trendline to Excel Charts
Chapter 42: Adding and Removing Worksheets
Chapter 44: Adding, Editing, and Deleting Comments
Chapter 45: Using Conditional Formatting to Change Cell Appearance
Chapter 56: Creating and Saving a New Workbook
Chapter 59: Creating Custom AutoFill Lists
Chapter 60: Cut, Copy, and Paste in Microsoft Excel
Chapter 63: Using Data Bars, Color Scales, and Icon Sets
Chapter 64: Displaying Formulas on a Worksheet
Chapter 65: Dragging and Dropping Cells
Chapter 66: Editing Cell Contents
Chapter 67: Enhancing Worksheets Using Themes
Chapter 68: Entering Numbers as Text
Chapter 69: Entering Text, Numbers, and Dates
Chapter 70: Filtering Data in Microsoft Excel
Chapter 73: Freezing Print Rows and Columns
Chapter 74: Formatting Excel Charts
Chapter 78: Basic Math Formulas in Microsoft Excel
Chapter 79: Grouping Multiple Objects in Excel
Chapter 81: Hiding and Unhiding Worksheets
Chapter 82: Inserting and Deleting Cells, Rows, and Columns
Chapter 83: Inserting Shapes and Screenshots
Chapter 85: Introduction to Basic Excel Formulas
Chapter 89: Merging Cells and Wrapping Text
Chapter 90: Creating Sparklines (Mini Graphs)
Chapter 91: Modifying Multiple Worksheets Simultaneously
Chapter 92: Changing the Chart Type
Chapter 94: Moving or Copying Worksheets
Chapter 95: Navigating an Excel Workbook
Chapter 96: Inserting Online Images into Excel
Chapter 97: Opening Workbooks and Using Save As Options
Chapter 101: Password Protecting an Excel Workbook
Chapter 102: Printing a Selected Range of Cells
Chapter 103: Protecting Part of a Worksheet
Chapter 104: Removing Duplicate Entries from Data
Chapter 105: Renaming, Copying, and Moving Worksheets
Chapter 107: Saving and Opening OneDrive Files
Chapter 108: Searching for Values in a Workbook
Chapter 109: Selecting Cells for Formatting
Chapter 113: Using the Format Painter
Chapter 122: Useful COUNT Functions in Excel
Chapter 123: Using the IF Function in Microsoft Excel
Chapter 125: Using Number Formats
Chapter 129: Using Excel Templates
Chapter 133: Worksheet Navigation and Colored Worksheet Tabs
Chapter 11: Creating and Managing a Pick List
Chapter 19: How to Enter Numbers and Retain Leading Zeros
Chapter 20: Inserting the Date and Time as Static or Dynamic Values
Chapter 22: Moving Swiftly Between Workbooks and Windows
Chapter 24: Recommended Charts and Quick Chart Creation
Chapter 26: Referencing a PivotTable Value in a Formula
Chapter 28: Creating Separate Worksheets from a Single PivotTable
Chapter 31: Testing What-If Scenarios with Goal Seek
Chapter 33: Using Scenarios to Experiment with Different Inputs
Chapter 35: Using the Fill Handle for Quick Data Patterns
Chapter 36: Working Out Mortgage Repayments
Chapter 41: Adding and Removing Borders from a Cell Selection
Chapter 46: Applying a Date Format to a Cell or Range
Chapter 47: Cell Content Alignment and Orientation
Chapter 48: Changing Column Widths and Row Heights
Chapter 51: Converting Data to a Table for Better Formatting
Chapter 54: Creating a Chart Using the Long or Short Method
Chapter 55: Creating a Conditional Formatting Rule from Scratch
Chapter 57: Creating and Using Your Own Excel Template
Chapter 61: Date Manipulation Functions in Excel
Chapter 62: DATEDIF: A Useful but Hidden Excel Formula
Chapter 75: Formatting Chart Elements
Chapter 77: Using Formulas Across Worksheets
Chapter 84: Introducing SUMIF, COUNTIF, and AVERAGEIF Functions
Chapter 86: Linking to Data on a Webpage
Chapter 87: Making Use of Named Cells and Ranges
Chapter 93: Modifying Typeface, Font Size, and Font Colour
Chapter 98: Understanding the Order of Operations (BODMAS) in Excel
Chapter 111: Text Manipulation Using Excel Functions
Chapter 112: Using the Fill Handle
Chapter 114: Using the New Recommended Charts Feature
Chapter 117: Using the SUM Function
Chapter 118: Undo and Redo Actions
Chapter 120: Using the IF Function to Hide Excel Errors
Chapter 121: Using the TEXT Function to Format Numbers
Chapter 124: Using Graphical Objects and Mathematical Operators
Chapter 128: Using Text to Columns Effectively
Chapter 131: Using Top and Bottom Rules in Conditional Formatting
Chapter 132: Viewing and Scrolling Multiple Workbooks
The Complete Excel Bootcamp: Beginner to Advanced
About Lesson

Chapter 121: Using the TEXT Function to Format Numbers

Chapter Description

In this chapter, you’ll learn how to use Excel’s TEXT function to format numbers, dates, times, currencies, and percentages without changing the original values. The TEXT function is useful when combining formatted numbers with text or creating customized reports.

You’ll explore different formatting codes and practical examples for presenting data professionally.

This lesson is especially useful for invoices, dashboards, financial reports, employee records, and automated reporting systems.

What You’ll Learn

  • Understanding the TEXT function
  • Formatting dates and times
  • Formatting currencies and percentages
  • Applying custom number formats
  • Combining formatted values with text
  • Common formatting codes
  • Best practices for using TEXT

Learning Outcome

By the end of this chapter, you’ll be able to confidently format numbers and dates using the TEXT function, making your Excel reports more professional and easier to understand.

Previous
Next

Subscribe Our Newsletter For
Latest Updates

Get in touch!

Fusce varius, dolor tempor interdum tristiquei bibendum.
Facebook Behance Instagram Pinterest Youtube

Company Info

Useful Links

recent post

  • 20 April, 2024
  • 20 April, 2024
Copyright © 2026 Skillart. All Rights Reserved.