Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Compare Two Lists in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • How to Create Column Chart in Excel
  • Reverse List in Excel
  • Working With Tables in Excel

References

  • How to use Excel ROWS Function
  • Count rows with at least n matching values
  • How to get first column number in range in Excel
  • How to use Excel MMULT Function
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation specific characters only
  • Excel Data validation whole percentage only
  • Excel Data validation allow uppercase only
  • Excel Data validation no punctuation
  • Excel Data validation only dates between

Convert Text to Numbers in Excel

by

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

Atimes user enter inverted comma before inputting data values in a cell which automatically converts a number to text.

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

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

Worked Example:   Assign points based on late time in Excel

2. Numbers preceded by an apostrophe are also treated as text. Select cell A5 and manually remove the apostrophe.

3a. You can also combine step 1 and 2 by adding an empty cell to the range A1:A5. By doing this, you let Excelknow that these text strings are numbers. Copy an empty cell.

Worked Example:   Remove last characters from right in a cell in Excel

3b. Select the range A1:A5, right click, and then click Paste Special.

3c. Click Add.

3d. Click OK.

Result. All numbers are right-aligned and treated as numbers.

Worked Example:   Strikethrough in Excel

4a. You can also use the VALUE function.

4b. Here’s another example. Use the Right function (or any other text function) to extract characters from a text string and then use the VALUE function to convert these characters to a number.

Post navigation

Previous Post:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

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

Logical Functions

  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel FALSE Function
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Dynamic date list in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Count times in a specific range in Excel
  • Get first day of previous month in Excel
  • How to get workdays between dates in Excel

Grouping

  • Running count group by n size in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel

General

  • Convert column number to letter in Excel
  • How to calculate percentage discount in Excel
  • How to increase by percentage in Excel
  • How to count total number of cells in a rectangular range in Excel
  • Share Excel data with Word documents
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning