Converting Text to Numeric Data in Excel

About this tutorial:

Video duration: 3:44
This video demonstrates how to convert textual numeric values in Excel to numerical data.

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

12 thoughts on “Converting Text to Numeric Data in Excel


    (October 19, 2018 - 7:29 pm)

    it worked perfectly, thanks so much. you are awesome brother


    (October 19, 2018 - 7:29 pm)

    Awful video, BRUH

    David Rahman

    (October 19, 2018 - 7:29 pm)

    Nice video. Unfortunately it is not working on my computer. I am frustrated to convert text data to number in Excel 2013. I followed all the rules but it is not working. I got data file from India and I live in Netherlands. I cannot data from txt to number. Why it is complicated. I can share my file with you perhaps you can examin. I am really frustrated with this issue. I am angry on Microsoft office developer. Can you please help me?

    Dylon Bennett

    (October 19, 2018 - 7:29 pm)

    This is a really bad way of doing this in my opinion and also how does this take a text value and convert it to numerical? It doesn't show this at all


    (October 19, 2018 - 7:29 pm)

    does not work


    (October 19, 2018 - 7:29 pm)

    this is very bad way to make numerical collums….all u have to do is select all fields with u need to be numeric than right click "Format cells.." and chose "Number" there u can also chose if there ll be minus number or how many decimals your number need…

    Christopher Beck

    (October 19, 2018 - 7:29 pm)

    Thanks guy (tlbdc080550).
    That was easy.
    I'm glad I found your answer.

    Amit Redfm

    (October 19, 2018 - 7:29 pm)

    Really Help Full Superb !!


    (October 19, 2018 - 7:29 pm)

    5 second summary:
    Type 1 into a blank cell somewhere.
    Copy that cell.
    Select the numbers as text you want to convert.
    Paste special: multiply.


    (October 19, 2018 - 7:29 pm)

    Clear and to the point. Great. Thank you!!!


    (October 19, 2018 - 7:29 pm)

    Magic you just saved me alot of time in doing our logistics report !!!


    (October 19, 2018 - 7:29 pm)

    To the point… Beautiful Technique…

Leave a Reply

Your email address will not be published. Required fields are marked *