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: OfficeTutes.com

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

    JoinJohnLu

    (October 19, 2018 - 7:29 pm)

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

    JohnnyO

    (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

    ALCI ACOSTA JONES

    (October 19, 2018 - 7:29 pm)

    does not work

    weedboyx

    (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 !!

    psyklone55

    (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.
    Done.

    elenitran

    (October 19, 2018 - 7:29 pm)

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

    Airwulf

    (October 19, 2018 - 7:29 pm)

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

    xaufad

    (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 *