How to Convert Text to Numbers in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2024

ความคิดเห็น • 50

  • @SimonSezIT
    @SimonSezIT  3 ปีที่แล้ว

    ✅ Download the free course files to follow along ➡www.simonsezit.com/excel-dashboards-instructor-files/
    🔥Check out our FREE 300+ hour training course playlist here 👉th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
    🚀Level up your Excel skill set with this free playlist 👉th-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html

  • @karthikramaswamy2495
    @karthikramaswamy2495 7 หลายเดือนก่อน +1

    Really a wonderful set of ideas to convert text to numbers! Thanks, sir! It was very helpful for resolving my issue!!

    • @SimonSezIT
      @SimonSezIT  7 หลายเดือนก่อน

      Glad it was helpful! Thanks for watching 😊
      🔥Check out our FREE 300+ hour training course playlist here 👉
      th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

  • @KnowledgeFeriwala
    @KnowledgeFeriwala 3 ปีที่แล้ว +2

    Life saving hack. Thank you so much. The multiply option worked for me. Great tips.

    • @SimonSezIT
      @SimonSezIT  3 ปีที่แล้ว

      Glad you like it

  • @Manoj-fi6ks
    @Manoj-fi6ks 3 ปีที่แล้ว +1

    Thanks, Ashby This is helpful, Would it be possible for you to post a detailed video for Date format changes. Example Dates which comes with a timestamp hidden when exported from an application

  • @Kevin-g3g1v
    @Kevin-g3g1v 7 หลายเดือนก่อน

    Hi, Simon, thanks for your powerful knowledge .
    I use an Excel file including 20 or more sheets to download from internet, some stock data, like date, open, high, low, close, volume. Problem is Number Stored in Text. I have to convert each sheet into Number. You must have some great ideas to fix it, do you? Any excel formula to convert text into number?

    • @chosenandblessed9040
      @chosenandblessed9040 24 วันที่ผ่านมา

      Do you now know how to do it

    • @Kevin-g3g1v
      @Kevin-g3g1v 24 วันที่ผ่านมา

      @@chosenandblessed9040 =value(trim(clean(a1)))

  • @ektajain3983
    @ektajain3983 7 หลายเดือนก่อน

    Thanks a lot ❤

    • @SimonSezIT
      @SimonSezIT  7 หลายเดือนก่อน

      You are very welcome! Glad it was helpful. 🙂
      🔥Check out our FREE 300+ hour training course playlist here 👉
      th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

  • @ksumar
    @ksumar 2 ปีที่แล้ว +3

    Great but how can you write a formula if you had thousands of numbers, some were text and others were numbers.
    I just want = F2, to a number! and regardless of what is in F2 everything gets converted to proper number!

  • @wolveriness
    @wolveriness ปีที่แล้ว

    Excellent instruction. Well worth subscribing.

    • @SimonSezIT
      @SimonSezIT  ปีที่แล้ว

      Thanks for the sub!

  • @kiokyodora8657
    @kiokyodora8657 6 หลายเดือนก่อน

    My warning drop-down menu doesn't have "convert to number" instead it was replaced by update formula or something (my excel isn't in English and can't seems to change it.) and didn't work as intended when clicked on. I'm new to this program.

  • @asmaeelhaouzi7200
    @asmaeelhaouzi7200 ปีที่แล้ว

    THANK YOU SO SO MUCH

  • @raphapam07
    @raphapam07 ปีที่แล้ว

    This does note solve my issue... I've copied and paste a E-mail table with Numbers, and it shows a Lot of Blanck spaces before the numbers.
    the =Trim() doesn't help...

  • @ivaylonikolov3446
    @ivaylonikolov3446 ปีที่แล้ว

    Top! Thank you!

    • @SimonSezIT
      @SimonSezIT  ปีที่แล้ว

      Glad you are enjoying the training. 😀

  • @dilumdilshan2430
    @dilumdilshan2430 ปีที่แล้ว +1

    Why is excel asking to sort my numbers alphabetically? If anyone suffers from this problem, use the "text to columns" option in the "Data tab". This happens especially when we are using datasets exported from devices like GPSs. The coordinates are sometimes stored as strings (within " " marks. Example - "6.1234" ; but excel doesn't show the quotations in it). So when we use those data in excel, it doesn't act as a numbering value so we can't just use text to numbers solutions to convert those data into numbers. With the "text to Column" option we can isolate the numbering part (from "6.1234" to 6.1234). Hope this might save someone's day!!

  • @armindolopes2248
    @armindolopes2248 ปีที่แล้ว

    Thks.

  • @amitkumarhalder8836
    @amitkumarhalder8836 ปีที่แล้ว

    i want to know text to convert a number, not number to text. such like that "tax 5%".
    pls solve my problem.

  • @shwetashorts8341
    @shwetashorts8341 2 ปีที่แล้ว +2

    Even the paste special method is not working for me, please help!

    • @annakor8680
      @annakor8680 7 หลายเดือนก่อน

      Did you find a solution cause I’m in the same situation

  • @eslamfahmy87
    @eslamfahmy87 ปีที่แล้ว

    thanks 😊

  • @paribaghel1758
    @paribaghel1758 2 ปีที่แล้ว

    I'm from delhi. Thnx u so much 💖

    • @SimonSezIT
      @SimonSezIT  2 ปีที่แล้ว

      Most welcome 😊 💖

  • @HYN_Media
    @HYN_Media 2 ปีที่แล้ว +2

    How can you fix a whole sheet that is stored as text though? It would take forever to do this for each cell.

    • @SimonSezIT
      @SimonSezIT  2 ปีที่แล้ว +1

      You would need to select all the cells in the column before applying either of the methods mentioned in this video. Selecting one cell at a time was done for demonstration purposes. You can also try using the NUMBERVALUE function. Hope this helps!

    • @danajohnston
      @danajohnston ปีที่แล้ว

      It doesn't help! Please demonstrate this.@@SimonSezIT

  • @wendymcdonald5145
    @wendymcdonald5145 11 หลายเดือนก่อน

    The method of multiplying by 1 does not work.

  • @hanzalahameen8378
    @hanzalahameen8378 ปีที่แล้ว

    I won't able to do, because i've used MID functions

  • @DevletCirti
    @DevletCirti ปีที่แล้ว

    THXXXX

  • @RonDavidowicz
    @RonDavidowicz 3 ปีที่แล้ว +1

    At 1:22 you said “Excel is mistakenly storing them as numbers…”, you meant to say “…as text…”

  • @chetrshah
    @chetrshah ปีที่แล้ว

    why dont we use Numbervalue function?

    • @awadhi7
      @awadhi7 ปีที่แล้ว

      Thanks a lot, I've been looking for a solution for this

    • @chetrshah
      @chetrshah ปีที่แล้ว

      @@awadhi7 u r welcome. Now you can embed AI assist which will tell you which formula to use if you ask in simple English words.

  • @Accuface2000
    @Accuface2000 2 ปีที่แล้ว +1

    We all know how to convert each cell to number. The question is how to mass convert a column to numbers?

    • @SimonSezIT
      @SimonSezIT  2 ปีที่แล้ว

      You would need to select all the cells in the column before applying either of the methods mentioned in this video. Selecting one cell at a time was done for demonstration purposes. You can also try using the NUMBERVALUE function. Hope this helps!

    • @danajohnston
      @danajohnston ปีที่แล้ว

      It doesn't help! Please demonstrate this.@@SimonSezIT

    • @danajohnston
      @danajohnston ปีที่แล้ว

      YES, we can all fix one or two cells. The only reason for a tutorial is to fix a lot all at once, and this is no help at all.

  • @hayleywilson8266
    @hayleywilson8266 2 ปีที่แล้ว

    These tips didn’t work for me

  • @Kate98755
    @Kate98755 หลายเดือนก่อน

    It didn’t work

  • @b_tang
    @b_tang 6 หลายเดือนก่อน

    Could have been a 30 second video

  • @e8lattice487
    @e8lattice487 2 ปีที่แล้ว +1

    this is so wrong, it took you a full 5 minutes to get to the solution which is to just to just copy paste. im disliking this video. hope you can improve.

  • @GajendraSingh-rl5fp
    @GajendraSingh-rl5fp ปีที่แล้ว +1

    Waste

  • @dmobxts
    @dmobxts ปีที่แล้ว

    to much explenation zzzzzzzzzzzzz.

  • @Kevin-g3g1v
    @Kevin-g3g1v 7 หลายเดือนก่อน

    Find it. =VALUE(TRIM(CLEAN(B2)))