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

[@swamy96769]

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

[@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.

[@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!

[@nurinarifah9091]

Thank you sooo much!

[@PresentationProcess]

You're welcome!

[@datalab365]

Very useful brother.

[@PresentationProcess]

Thank you

[@erick.rodrigues86]

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

[@adamkamundi9879]

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

[@Chris_Coar]

I totally forgot about the Replace option, thanks man

[@joshuacampbell5673]

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

[@deafdogdesign]

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

[@p4nnarith168]

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

[@PresentationProcess]

Glad it was helpful!

[@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.

[@jean-francoisplante4347]

ctrl-h saved my life. Thank you!!

[@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

[@mustafadarrar5880]

You're God sent. Thanks brother.

[@PresentationProcess]

Glad to help

[@ca.ravigoyal8128]

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

[@harshalpatil2111]

Lovely ... So nice !!

[@souravlohan5873]

thanks a ton. Saved a lot of my time

[@PresentationProcess]

Glad it helped!

[@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!

[@AnilSingh-mj6lj]

Brief Video but Very Clear and Helpful!

[@harishdamo3905]

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

[@genakjain]

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

[@jenifferlee3571]

thanks for saving my day!!

[@PresentationProcess]

Happy to help!

[@paolamonnihenderson]

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

[@rajivsukumaran]

Thank you so much. It was very useful

[@PresentationProcess]

Glad it was helpful!

[@divyarao8075]

Thanks a lot ! You made my day. 😊

[@radhakv141]

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

[@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.

[@manojroy2687]

THANKS

[@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

[@malcolmmac7797]

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

[@rizan333]

This really helped me bro. Thanks a lot

[@maksudhasan8489]

Great content. I really appreciate. Thanks.

[@Boerikoe]

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

[@rayc9297]

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

[@PresentationProcess]

Glad it helped!

[@MyselfAdityaSingh]

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

[@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...

[@jitendersingh9757]

Thanks you for your support
Sir

[@PresentationProcess]

Always welcome

[@cadeepakgoyal7500]

Thank you very much. really helpful. god bless you

[@ionutmoromete7186]

It helped me. thanks

[@uditjariwala2551]

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

[@vishalbrahmbhatt157]

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

[@sherishahmir]

Thanks for the solution, perfectly work out.

[@kofi-tawiahagyeman]

Wow!!! Concise & Precise!!!

[@azman73681]

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

[@ngoclanie6687]

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

[@muhleraymond3386]

BRAVO!!!!!! HELPFUL

[@davida6146]

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

[@jagadishmohanty4728]

Thanks for useful formulas. Thanks a lot

[@madhavtewary2421]

Extremely useful video sir

[@pennyyanke2562]

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

[@MrIndianmusic]

Very true sir 😁

[@worthityoutube1]

THANKS & GREAT FOR SIMPLE BUT WONDERFUL TIPS

[@tasneembrnawi3083]

Thank you so much u have saved my FYP

[@sameerhadwal5204]

Thank you, it's great help

[@PhuongMyLuong]

Hi, thank you for your video. I tried all your tricks to convert text format numbers into numbers but it still didn't work out.

[@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

[@YoSoyPalomo]

great!!! What a big problem solved without formulas

[@yeshosingh5897]

Excellent tutorial - clear and to the point .

[@Shalini-Dh]

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

[@santoshmallur7035]

Thank you, sir!!!

[@ivanomatijevic8822]

Thank you, you saved me a lot!

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

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

[@eminimamoglu3072]

You saved my life. Thanks

[@veenav9967]

Very very good

[@deletechannel1104]

Many many thanks 🎉

[@nileshbadekar3504]

Thank you bhau

[@RayRay-lj9zb]

Great guy!
...Saved a soul

[@pravinghanchi4093]

Thank you- helpful

[@sqoches]

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

[@radhakv141]

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

[@madhusudhanaraoalampally4342]

Excellent explanation

[@ntaylor81]

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

[@tinthuzarhtwe215]

How to make column C.

[@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?

[@nareshjoshi165]

Thank U so much

[@PresentationProcess]

Most welcome

[@alokbansal3511]

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

[@Sharvank9191]

A big thanks to You

[@abichenvaazha]

4th Option is easy,, Thanks

[@shubhamvashistha4369]

Thank you 😊

[@Prasaad.Yepuri]

We have numbers in text format - like 2,74 (decimal point separated by comma)... Could you plz guide me..how to correct text format values to number format (we need comma also for decimal points in French language)
Thanks in advance ...🤝

[@vikasgupta-ts8ek]

Good One Thanks i was very Helpful.

[@SurajKumar-wj7dc]

Thanks sir 🙏 so much

[@balachandranm8300]

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

[@bukolaadebayo1891]

Very concise and helpful. Thanks!

[@jodavila16]

Freat Video, Thanks!!

[@ajaypremkaushalpareek5017]

Even after applying Ctrl H and replacing with , not able to get value not getting smart tag, can you please help ?

[@navaskmk]

usefull love it

[@PresentationProcess]

Glad to hear that

[@izurukira1160]

Thanks 👍🏻

[@miloshalda2031]

This was a helpful video. Thanks!

[@sambitguru8374]

It was really helpful. Thanks a lot.

[@matthewbutler9328]

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

[@naledieabochabelamoyo5018]

Thank you so much- this was really helpful

[@Jay_Ho992]

Very useful

[@kristofrancis3064]

Thank you, smartly presented

[@ranacool7790]

Thank U sir ❤️

[@ajaypremkaushalpareek5017]

I have copied some rates form email, but not able to get it converted in numbers none of shown in video worked , any other method !!

[@ambikagoenka997]

Very helpful

[@badtank9020]

You Sir are awesome! Thank you so much!

[@selvakumarraja95]

You saved my time, thanks bro