How to Convert Text to Numbers in Excel (5 Ways!)

[@PresentationProcess]

Complete Excel Foundation Course: shop.presentation-process.com/p/complete-excel-foundation-course

[@akamstech8184]

Good day, I'm Akamstech i really need a help from you, i have a Data in excel, which is mask but i can't un_mask it or set it back again. the data is just like this ( 054239**** ) i want to restore the missing number back, please sir can you help out, my work and life depend on it.

[@Aidits9442]

Bro help chahiye. I ll pay

[@datalab365]

Very useful brother.

[@PresentationProcess]

Thank you

[@swamy96769]

Your explanation is easy, clear, your voice also very clear, keep it up bro

[@p4nnarith168]

Very helpful in identifying the error and how to fix in each case! Thanks!

[@PresentationProcess]

Glad it was helpful!

[@adamkamundi9879]

Finally, the replace comma function did it for me. Thank you !

[@ca.ravigoyal8128]

Dhanywaad RamGopal for tell us many ways to convert a number.

[@NeelB3640]

Very easy direction, clear, concise, and to the point. You do not boast about subscribing to your channel. Very humble and your an excellent teacher!

[@joshuacampbell5673]

Thank you! The Replace all worked very well, especially when I needed to delete numerical units that were included in the cells.

[@sylverebryan8256]

Thank you so much. After watching more than an hour of videos, I finally found a way to change my text into numbers without distorting the numer. I really appreciate your video.

[@erick.rodrigues86]

"Paste Special" did the trick perfectly! Thank you very much, my friend! Now I can filter my data. 💪

[@deafdogdesign]

A very big THANK YOU!! Been searching for hours on why my function wasn't working and how to solve the issue!!

[@jean-francoisplante4347]

ctrl-h saved my life. Thank you!!

[@Chris_Coar]

I totally forgot about the Replace option, thanks man

[@rakeshsingh9323]

thanks for this video i was totally confused on green signal in sheet , but after watching this video my confusion is clear again thanks for this.

[@nurinarifah9091]

Thank you sooo much!

[@PresentationProcess]

You're welcome!

[@harishdamo3905]

Thank you so much, replace the comma helped me a lot

[@mustafadarrar5880]

You're God sent. Thanks brother.

[@PresentationProcess]

Glad to help

[@paolamonnihenderson]

Great video! The last trick you presented worked for me. Thank you!

[@souravlohan5873]

thanks a ton. Saved a lot of my time

[@PresentationProcess]

Glad it helped!

[@radhakv141]

Thank you for your nice explination of various methods, which helped me a lot in converting a large data into numbers.

[@AnilSingh-mj6lj]

Brief Video but Very Clear and Helpful!

[@jenifferlee3571]

thanks for saving my day!!

[@PresentationProcess]

Happy to help!

[@ansh-singh]

I found valuable it helped me a lot

[@chopensaji208]

Thank you very much sir. Solved the calculation problem while copying data from option chain to excel.

[@cadeepakgoyal7500]

Thank you very much. really helpful. god bless you

[@maksudhasan8489]

Great content. I really appreciate. Thanks.

[@rajivsukumaran]

Thank you so much. It was very useful

[@PresentationProcess]

Glad it was helpful!

[@karilockhart2654]

I have spent hours searching for a solution to a messy Etsy CSV file to no avail until the last step in your video. Thank you SO much! Subscribing now!

[@sherishahmir]

Thanks for the solution, perfectly work out.

[@genakjain]

very helpful and clearly spoken post, one of the best i have seen in you tube, keep it up please.

[@mrCetus]

Thanks for a very comprehensive video. Worked a charm.

[@vishalbrahmbhatt157]

Excellent.. Please make such more vidoes that can save huge amount of time in office.. On routine work

[@divyarao8075]

Thanks a lot ! You made my day. 😊

[@worthityoutube1]

THANKS & GREAT FOR SIMPLE BUT WONDERFUL TIPS

[@rizan333]

This really helped me bro. Thanks a lot

[@cmazloomi]

Genius! The best part is that with, special paste, text to columns and value function methods, you can convert the entire column. Microsoft support says this is not possible!! Brilliant solution. THANK YOU.

[@JamesMathew2023]

Thanks

[@Boerikoe]

Excellent video, clear, and straight to the point ! Thank you :)

[@MyselfAdityaSingh]

Thank you very much......bahut bahut dhanyawad

[@harshalpatil2111]

Lovely ... So nice !!

[@ngoclanie6687]

Thank you, finally, I found the way to solve this problem instead of tapping all of them again!

[@malcolmmac7797]

Great vid, text to columns worked for me. Cheers mate

[@jagadishmohanty4728]

Thanks for useful formulas. Thanks a lot

[@azman73681]

Thanks. Excellent. U solved my problems with all available solutions in a simple straight fwd method.

[@radhakv141]

Thank you for your nicely explained detailed video which helped me a lot.

[@sameerhadwal5204]

Thank you, it's great help

[@uditjariwala2551]

Thanks A Lot... Many videos have seen on YT but sir ji only you have put the solution for coma numbers

[@ionutmoromete7186]

It helped me. thanks

[@davida6146]

THANK YOU!!! I needed to convert a large list and using the tags took forever!!! The text to columns method was instant!

[@jitendersingh9757]

Thanks you for your support
Sir

[@PresentationProcess]

Always welcome

[@yeshosingh5897]

Excellent tutorial - clear and to the point .

[@rayc9297]

Found text to column works the best! Thanks for the tips, Your videos really helps a lot of frustration.

[@PresentationProcess]

Glad it helped!

[@alokbansal3511]

Nice presentation sir it help me lot, Thank you very much

[@kofi-tawiahagyeman]

Wow!!! Concise & Precise!!!

[@noorifayaz6714]

Thank you buddy, I have gone through with your video and tried all the tricks, but to my surprise only last trick worked. kudos to your video and you as well. all the best

[@madhavtewary2421]

Extremely useful video sir

[@tasneembrnawi3083]

Thank you so much u have saved my FYP

[@muhleraymond3386]

BRAVO!!!!!! HELPFUL

[@YoSoyPalomo]

great!!! What a big problem solved without formulas

[@manojroy2687]

THANKS

[@pennyyanke2562]

Thank you, I've been struggling with this for a long time

[@MrIndianmusic]

Very true sir 😁

[@Shalini-Dh]

thnx finally i got for what i was looking for..

[@deletechannel1104]

Many many thanks 🎉

[@ivanomatijevic8822]

Thank you, you saved me a lot!

[@sqoches]

Thank you very helpful, I had a space issue with my numbers in text format.

[@santoshmallur7035]

Thank you, sir!!!

[@bukolaadebayo1891]

Very concise and helpful. Thanks!

[@madhusudhanaraoalampally4342]

Excellent explanation

[@vikasgupta-ts8ek]

Good One Thanks i was very Helpful.

[@pravinghanchi4093]

Thank you- helpful

[@veenav9967]

Very very good

[@eminimamoglu3072]

You saved my life. Thanks

[@ntaylor81]

Thank you! Was looking for a solution for so long! The Control H did the trick!!

[@tinthuzarhtwe215]

How to make column C.

[@kristofrancis3064]

Thank you, smartly presented

[@Sharvank9191]

A big thanks to You

[@matthewbutler9328]

This is exactly what I was looking for, thank you.

[@naledieabochabelamoyo5018]

Thank you so much- this was really helpful

[@sambitguru8374]

It was really helpful. Thanks a lot.

[@Nogxme]

im in the middle of a class lesson , the teacher keeps making a theater presentation when people ask him questions, so happy i got help from this instead

[@badtank9020]

You Sir are awesome! Thank you so much!

[@RayRay-lj9zb]

Great guy!
...Saved a soul

[@miloshalda2031]

This was a helpful video. Thanks!

[@nileshbadekar3504]

Thank you bhau

[@abichenvaazha]

4th Option is easy,, Thanks

[@balachandranm8300]

Oh My God ! Thanks allot to you sir
A very useful video

[@allanpark6046]

Excellent, thank you.

[@sahilkamra5105]

Hello,
After converting the text into numbers, we are unable to apply basic formula like autosum .... Can you please check and let us know...

[@saileeparab70]

I copy paste a data from email like you mentioned then did find and replace still there are leading spaces in the number. How am to change it to proper million number format

[@shubhamvashistha4369]

Thank you 😊

[@nareshjoshi165]

Thank U so much

[@PresentationProcess]

Most welcome

[@annsoellaart3056]

Hi there, I followed all your steps & the text would not convert to number. The second last one just showed the word value in the empty cell. the only step that worked for me, was to show the numbers as false. What am I doing wrong?

[@shajibkumarguha234]

Really helpful. For large number of data, second option is the best.

[@SurajKumar-wj7dc]

Thanks sir 🙏 so much

[@ambikagoenka997]

Very helpful

[@davidfcma2937]

THANK YOU SO MUCH YOU MADE MY JOB SUPER EASY

[@Jay_Ho992]

Very useful

[@محمدالسايح-ج1ب]

thanks a lot.
i want know how put I. D. number then iteme or customers name appears?
thanks.

[@selvakumarraja95]

Thanks for Knowledge transfer 🙌

[@selvakumarraja95]

You saved my time, thanks bro

[@aamirkhawaja3072]

Thanks

[@adambevan2423]

brilliant! method2