How to convert text numbers in Excel to numbers

Source: Internet
Author: User
Tags numeric numeric value

How to convert text numbers in Excel to numbers:

In Excel, the system treats a number preceded by a half-width single quote as text, and for some purposes, the user can format the number as text by using the cell command on the Format menu. However, now that we need to convert the number of text formats in the worksheet to numbers, the following methods can be tried.

1. Convert one cell at a time

On the Tools menu, click Options, and then click the Error Checking tab (make sure that the Allow background error checking and number as text check boxes are selected). Select any cell that has a green error indicator in the upper-left corner. Next to the cell, click the button that appears, and then click Convert to Number.

2. Conversion of the entire area at a time

In a blank cell, enter the number "1". Select the cell, and on the Edit menu, click Copy. Select the range of cells that you want to convert to be stored as text numbers. On the Edit menu, click Paste Selective. Under Operations, click Multiply. Click the OK button.

3. Processing of special financial figures

Some financial programs display negative values with a minus sign "-" on the right side of the value. To convert this text string to a numeric value, you must return all text string characters except the rightmost character (that is, the minus sign), then multiply by "-1". For example, if the value in cell A2 is "156-", then the formula "=left (A2,len (A2)-1) *-1" Converts the text to a numeric "-156" and then operates with the above method.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.