+ Reply to Thread
Results 1 to 3 of 3

formula to extract numerical value with decimal not working

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    formula to extract numerical value with decimal not working

    I have data that where I extract numerical data but when there are decimals , it is extracting as whole number in columns B

    Instead of extracting 1.5 , extracting as a whole number 15

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-17-2010
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: formula to extract numerical value with decimal not working

    Try this with ctrl+chift+enter
    =MID(A1,MATCH(TRUE,ISNUMBER(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),0),COUNT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))+1)

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    Re: formula to extract numerical value with decimal not working

    Perfect Thank you for assistance

+ 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] Formula to extract numerical part at the end of text
    By rizmomin in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-14-2019, 10:50 PM
  2. [SOLVED] Converting Numerical Values to Time to then calculate duration in decimal format
    By andy867 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-15-2018, 11:34 PM
  3. Replies: 6
    Last Post: 10-22-2017, 10:36 AM
  4. [SOLVED] Formula needed to extract numbers from alpha numerical entry please
    By Twaddy006 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-14-2014, 05:26 PM
  5. [SOLVED] Left of decimal with numerical and text values
    By Bearack in forum Excel General
    Replies: 5
    Last Post: 09-20-2012, 12:07 PM
  6. Numerical Ratio to Return Decimal Equivalent
    By jevery in forum Excel General
    Replies: 2
    Last Post: 12-11-2009, 08:34 PM

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