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

Lookup and Reference Examples

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Find closest match in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel ROW Function
  • How to get last row in text data in Excel

Data Analysis Examples

  • Excel Pie Chart
  • Chart Axes in Excel
  • How to Use Solver Tool in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to Create Thermometer Chart in Excel

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation date in specific year
  • Excel Data validation unique values only
  • Excel Data validation specific characters only
  • Excel Data validation exists in list

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:   Number Decimal Places 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:   Sum race time splits 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:   How To Create To Do List Using Fancy Check Mark 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:

How to Copy Visible Cells Only in Excel

Next Post:

Spell Check 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
  • TRIM function: Description, Usage, Syntax, Examples and Explanation
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • Add line break based on OS in Excel
  • How to use double quotes inside a formula in Excel
  • How to calculate most recent day of week in Excel
  • Extract date from a date and time in Excel
  • Sum race time splits in Excel
  • Get day name from date in Excel
  • Count day of week between dates in Excel
  • Calculate cumulative loan principal payments in Excel
  • PV function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARDE function: Description, Usage, Syntax, Examples and Explanation
  • NPER function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles