+ Reply to Thread
Results 1 to 5 of 5

Convert Text format to Numbers

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Dubai, UAE
    MS-Off Ver
    2013
    Posts
    81

    Post Convert Text format to Numbers

    Unable to convert some texts in to number format.
    Someone please help me. File is attached with data.
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,443

    Re: Convert Text format to Numbers

    .
    Paste this into a routine module .. highlight all of the numbers only, click your button.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: Convert Text format to Numbers

    another way: Clear Format, use Text2Columns, replace comma to nothing (dot to nothing if necessary) then use number format

    edit:
    for dates use T2C with DMY option
    Attached Files Attached Files
    Last edited by sandy666; 06-08-2018 at 10:47 PM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  4. #4
    Registered User
    Join Date
    09-23-2014
    Location
    Dubai, UAE
    MS-Off Ver
    2013
    Posts
    81

    Re: Convert Text format to Numbers

    Its working now. Thank you all for the assistance

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,443

    Re: Convert Text format to Numbers

    .
    Happy we could help.

+ 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. Replies: 1
    Last Post: 05-07-2014, 04:56 AM
  2. Convert Text-Formatted Numbers To Number Format
    By accell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2014, 12:58 PM
  3. Convert and format numbers to text with VBA
    By TychaBrahe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2012, 01:17 PM
  4. [SOLVED] how to convert arabic numbers to english text format in excel?
    By ANURAG ARPAN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2006, 12:15 PM
  5. Replies: 1
    Last Post: 08-02-2006, 02:24 AM
  6. [SOLVED] How do you convert Arabic numbers to English text format?
    By amt0423 in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 08:00 PM
  7. Convert Text numbers to time format
    By jermsalerms in forum Excel General
    Replies: 3
    Last Post: 01-19-2006, 08:03 PM
  8. [SOLVED] Convert numbers from text format to number format
    By merlin68 in forum Excel General
    Replies: 4
    Last Post: 04-12-2005, 09:06 AM

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