+ Reply to Thread
Results 1 to 8 of 8

Convert text numbers to numbers

  1. #1
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Convert text numbers to numbers

    I can no longer just right click on a text numberered cell to convert it to number in my Excel 2019/W10 Pro.

    I used to be able to do so up to when i upgraded from W10 Home to W10 pro, so this is odd.

    My cells no longer have the little green corner warning triangle either.

    I've checked my Excel options, and they are still there to supposedly flag up such a problem.

    I've exhausted all the usual ways to do this conversion, without success.

    I'd appreciate help.
    ========================
    OK. I've found the Data option Text to Columns option, and this does the trick, albeit more awkwardly than the previously available mouse right-click.
    Attached Files Attached Files
    Last edited by Zarathrustra; 07-21-2020 at 03:20 AM. Reason: Solved

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Convert text numbers to numbers

    Select Column A

    Press Alt A E or ribbon Data > Text to columns
    Click finish

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Convert text numbers to numbers

    Wake them up by:
    Copy any blank cell (point to a blank cell then Ctrl-C)
    Highlight column A
    Paste special/ Operation: Add
    OK

    Like we try to add 0 to every cell in range to convert string into number
    Quang PT

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Convert text numbers to numbers

    If you want to use these strings in any arithmetic operation, you can leave them as is, the operation will coerce them automatically ( like =A1*56 or A1*a10...)

  5. #5
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Re: Convert text numbers to numbers

    Thanks Bo_Ry; that Alt A E is a nice short-cut.

  6. #6
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Re: Convert text numbers to numbers

    Thanks bebo; that works. Seems odd to me, but what the hell, it works!

  7. #7
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Re: Convert text numbers to numbers

    Thanks Pepe. Alas, I needed to use the text numbers as actual numbers later for a consistency check so had to get them as actual numbers in their original cells.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Convert text numbers to numbers

    No worries. That is "The way you speak"...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to convert a range from numbers to numbers stored as text (Text to Columns)
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2017, 05:50 PM
  2. [SOLVED] Convert numbers stored as text to numbers for range of data that changes
    By excel2425 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2014, 01:57 PM
  3. [SOLVED] Convert all numbers stored as text or custom formatted to numbers &no decimals - 40 sheets
    By synses in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 01:46 AM
  4. [SOLVED] How do you apply the int() in VBA in order to convert numbers stored as text to numbers
    By djaurit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 02:57 PM
  5. Replies: 2
    Last Post: 10-22-2009, 02:50 PM
  6. Convert numbers stored as text to numbers Excel 2000
    By Darlene in forum Excel General
    Replies: 6
    Last Post: 01-31-2006, 04:10 PM
  7. [SOLVED] How do I convert numbers stored as text with spaces to numbers
    By Baffuor in forum Excel General
    Replies: 1
    Last Post: 05-24-2005, 03:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1