Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Vlookup Examples in Excel
  • How to use Excel LOOKUP Function
  • Offset in Excel
  • How to use Excel MMULT Function

Data Analysis Examples

  • Managing Conditional Formatting Rules in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Remove Duplicates Example in Excel
  • How To Filter Data in Excel
  • How to Use Solver Tool in Excel

Data Validation Examples

  • Excel Data validation unique values only
  • Data validation must not exist in list
  • Excel Data validation must not contain
  • Excel Data validation must contain specific text
  • Excel Data validation no punctuation

Convert Numbers to Text in Excel

by

By default, numbers are right-aligned and text is left-aligned in Excel.

This example teaches you how to convert numbers to ‘text strings that represent numbers’.

1. Select the range A1:A4 and change the number format  to Text.

Worked Example:   Get days, hours, and minutes between dates in Excel

2. Precede a number by an apostrophe and it will also be treated as text.

3a. If you add text to a number and still want to format this number, use the TEXT function. Without using the TEXT function this would be the result.

Worked Example:   Create date range from two dates in Excel

3b. With the TEXT function.

Note: #,## is used to add comma’s to large numbers.

3c. Here’s another example. Apply a percentage format.

Note: use 0 to display the nearest integer value. Use 0.0 for one decimal place. Use 0.00 for two decimal places, etc.

Worked Example:   Change Fractions Format in Excel

3d. And another example. Format a date.

Note: use less/more m’s, d’s and y’s to change the appearance of the date.

Post navigation

Previous Post:

Merge Cells in Excel

Next Post:

Apply Previous Cell Styles Using Format Painter in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • How to count specific words in a range in Excel
  • Remove first character in a cell in Excel
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Join cells with comma in Excel
  • Dynamic date list in Excel
  • Get project end date in Excel
  • Extract date from a date and time in Excel
  • Convert time to time zone in Excel
  • Count dates in current month in Excel
  • Calculate loan interest in given year in Excel
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles