+ Reply to Thread
Results 1 to 7 of 7

Trying to convert a text to a numerical number from statement

  1. #1
    Registered User
    Join Date
    12-16-2014
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    24

    Trying to convert a text to a numerical number from statement

    I was wondering if there is anyone out there that can help me convert a copied text number into a numerical value in excel. I have attached the file if you are interested.
    I have tried for a awhile and have not accomplished anything on it.

    Thanks,

    J

    a b c
    Amount
    −16.00 −16.00 #VALUE! NEEDS TO BE CONVERTED TO A NUMBER
    −14.06 −14.06
    −64.99 −64.99
    −23.60 −23.60


    I have tried =-1*a1 result would be #value
    I aslo tried 1 in a cell then copy paste special after highlighting column A picking multiply and still nothing.
    I tried to upload the file but its not working so here is the mock up of it.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Trying to convert a text to a numerical number from statement

    Have you tried the VALUE function?
    Martin

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Trying to convert a text to a numerical number from statement

    Highlight the data > Find & Select > Replace

    Find what: −
    Replace with: (leave blank)

    Replace All

  4. #4
    Registered User
    Join Date
    12-16-2014
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    24

    Re: Trying to convert a text to a numerical number from statement

    Yes, I tried value(a1) and still I get the value#.

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Trying to convert a text to a numerical number from statement

    Try this formula
    Enter in B1 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Or use SUBSTITUTE function
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B
    1 -16.00 16.00
    2 -14.06 14.06
    3 -64.99 64.99
    4 -23.60 23.60
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  6. #6
    Registered User
    Join Date
    12-16-2014
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    24

    Re: Trying to convert a text to a numerical number from statement

    I tried the find and select and could not find anything

  7. #7
    Registered User
    Join Date
    12-16-2014
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    24

    Re: Trying to convert a text to a numerical number from statement

    Thank you AlKey, it works!

+ 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. [SOLVED] Convert numerical into text
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2013, 09:35 PM
  2. Excel 2007 : Convert Numerical Expression to Number
    By suresh968 in forum Excel General
    Replies: 1
    Last Post: 03-15-2012, 09:49 AM
  3. how to convert numerical figure into text
    By ckchuah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2005, 06:05 PM
  4. [SOLVED] HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
    By Paul B in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 PM
  5. [SOLVED] HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
    By Paul B in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 05:05 PM
  6. HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
    By KRISHNAMOHAN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  7. [SOLVED] HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
    By Paul B in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 09:05 AM
  8. [SOLVED] HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT
    By KRISHNAMOHAN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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