+ Reply to Thread
Results 1 to 4 of 4

need to make text into number format

  1. 05-20-2014, 09:32 AM #1
    stvbrown2184
    stvbrown2184 is offline
    Registered User
    Join Date
    05-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    51

    need to make text into number format

    Please see attached file. In column D, I need a formula to make either column B or C into a number format.

    EXCEL HELP PRICE.xlsx
    Reply With QuoteRegister To Reply
  2. 05-20-2014, 09:39 AM #2
    AlKey
    AlKey is offline
    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: need to make text into number format

    In D2

    =SUBSTITUTE(B2,CHAR(160),"")+0
    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
    Reply With QuoteRegister To Reply
  3. 05-20-2014, 09:42 AM #3
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: need to make text into number format

    Hi,

    You need to remove all the non-printable characters in column C first.

    Highlight that column. Open the Find & Replace box. For Find what: hold down ALT and press 0160 on the numeric keypad. Leave the Replace with: box blank. Click Replace All.

    A formula such as 1*C2 should work fine now.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  4. 05-20-2014, 09:42 AM #4
    AlKey
    AlKey is offline
    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: need to make text into number format

    Thank you for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  2. make number formatting real, not just format
    By oompa_l in forum Excel General
    Replies: 7
    Last Post: 06-16-2008, 07:15 PM
  3. [SOLVED] How to make text data export to excel in text format.
    By ~@%.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2006, 11:20 PM
  4. Custom format cells - how to make it say < number
    By liniis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2006, 07:30 PM
  5. make:Custom Number Format
    By robertjtucker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2006, 02:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1