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

[@p4nnarith168]

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

[@PresentationProcess]

Glad it was helpful!

[@Chris_Coar]

I totally forgot about the Replace option, thanks man

[@erick.rodrigues86]

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

[@davida6146]

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

[@ca.ravigoyal8128]

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

[@Boerikoe]

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

[@rajivsukumaran]

Thank you so much. It was very useful

[@PresentationProcess]

Glad it was helpful!

[@genakjain]

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

[@rayc9297]

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

[@PresentationProcess]

Glad it helped!

[@jean-francoisplante4347]

ctrl-h saved my life. Thank you!!

[@malcolmmac7797]

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

[@uditjariwala2551]

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

[@jitendersingh9757]

Thanks you for your support Sir

[@PresentationProcess]

Always welcome

[@vishalbrahmbhatt157]

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

[@YoSoyPalomo]

great!!! What a big problem solved without formulas

[@shajibkumarguha234]

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

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

[@matthewbutler9328]

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

[@eminimamoglu3072]

You saved my life. Thanks

[@jenifferlee3571]

thanks for saving my day!!

[@PresentationProcess]

Happy to help!

[@miloshalda2031]

This was a helpful video. Thanks!

[@ivanomatijevic8822]

Thank you, you saved me a lot!

[@veenav9967]

Very very good

[@radhakv141]

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

[@manojroy2687]

THANKS

[@alokbansal3511]

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

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

[@izzyr4027]

Very clear and to the point - thank you.

[@abichenvaazha]

4th Option is easy,, Thanks

[@alexmendez9792]

LIKE, THANK YOU.... I can do more complex stuff but now that the smart label did not automatically appeared in my number list I was stumped.

[@nareshjoshi165]

Thank U so much

[@PresentationProcess]

Most welcome

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

[@wingwong8670]

very useful.

[@navaskmk]

usefull love it

[@PresentationProcess]

Glad to hear that

[@hazemsultan9284]

I Love u, u solve for me a problem :)

[@princerajan325]

Thank You So Much

[@shelfaabellar2967]

What about number that starts with 0? Like 0026 and i want to keep it as 0026 andd not just 26

[@vishalagarwal6863]

thanks

[@ratangowda2821]

On my laptop whenever I restart the system and open any excel which already saved the format automatically falls to Accounting from General..... Can anybody tell me how to fix this issue to keep General format ?

[@tiffy5498]

I tried all above, apparently in my case doesnot work. I am not sure what to do. I used ISTEXT which said true, and i am still not able to convert to number using any method above

[@shakeeldanish7405]

Thabk you

[@tomotobe]

i always wonder,,, why cant i change the TEXT format to NUMBER format just using the FORMAT CELL - and select the number format.

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

[@pramodbiswal1111]

Sir can u solve my problem if i type in one cell 20*40 and i want its ans in other cell 800 how can do it

[@PresentationProcess]

Enter the formula in the cell where you want the answer to appear. Please watch our excel videos on formulas for a more detailed explanation.

[@princekamboj1620]

Sir, any program on Excel on Udemy of yours !!

[@lisacummings6686]

Great help in convert time text to value...4 youtube videos to get this answer!

[@ottoferenczi284]

This is the 5th video I’m watching but still don’t get it. Once you do something at 2.15 which is not obvious and I stuck there...

[@prasunanand]

None worked for my data.

[@incongnitox2657]

NONE OF THIS WORKS FOR ME :(

[@raykalita3928]

Tried everything nothing wrks

[@amroar4996]

🎇🎇🎇🎇🎇✨✨✨✨

[@whitebiscut4688]

But

[@amritaingole9753]

None of these steps works for me

[@chandreshshukla4368]

Same with me

[@datalab365]

Very useful brother.

[@PresentationProcess]

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

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

[@deafdogdesign]

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

[@nurinarifah9091]

Thank you sooo much!

[@PresentationProcess]

You're welcome!

[@adambevan2423]

brilliant! method2

[@swamy96769]

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

[@harshalpatil2111]

Lovely ... So nice !!

[@ionutmoromete7186]

It helped me. thanks

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

[@nileshbadekar3504]

Thank you bhau

[@aamirkhawaja3072]

Thanks

[@divyarao8075]

Thanks a lot ! You made my day. 😊

[@sarapetersson9886]

None of these worked for me. The only thing that did in the end was: =VALUE(CONCAT(SUBSTITUTE(IFERROR(VALUE(SUBSTITUTE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),".",10)),""),10,".")))

[@Kids.colour444]

Thnkx gud

[@CaninosVermelhos]

how can i do that minus formula... i have Red Hinox (7) on a3 on a4 i have =countif (D3:D9, "TRUE") that equal 0 a3 i want to be the (7) and d9 is my last checkbox, i have from d3 to d9 7 checkboxes, i want to check the box and minus the (7) from the a3 to be Red Hinox (6) each time i check a box it decrease the number on () and i have the results like this on a5 = a3-a4, i want to a3 read only the number on ( ), how can i do that? Without the Red Hinox (7) only 7 on a3 it works like a charm, but i want to decrease on the () and with the letters beside like Red Hinox (7) to Red Hinox (6)

[@nataliiaiatsenko7779]

Thanks a lot!

[@PresentationProcess]

You're welcome!

[@mariahaynes6214]

I have a challenge for you! can we morph and zoom excel charts into PPT...MS says we can't!

[@TarachandKhatri]

I just wants know keyboard shortcut for it.

[@kshravya6219]

Idk why not even a single option worked out.may be due to my old version of excel....anyway nice video, well explained.

[@ngoclanie6687]

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

[@jesahmaligon7456]

Example if i use. "One Hundred" instead numeric number 100 how to solve.

[@cadeepakgoyal7500]

Thank you very much. really helpful. god bless you

[@abeedthings4274]

What if my number have a currency symbol with it, how to convert it? Anyone? Please.

[@ajaypremkaushalpareek5017]

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

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

[@sqoches]

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

[@abhishekpandey3070]

not working i have a salary column with $ sign i tried all trick but unable to convert it !!!!

[@pramodbiswal1111]

Sir can u solve my problem if i type in one cell 20*40 and i want its ans in other cell 800 how can do it

[@pennyyanke2562]

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

[@MrIndianmusic]

Very true sir 😁

[@dilipsuthar1836]

I have seen yr video "How to convert Text to Numbers". It is secondary way to fix the problem. I would like u to help me with primary solution i.e. how to avoid the data to b saved / copied in text format. i have a user form with 13 column (13 Textbox) to input the data on the worksheet1, the same data is captured into a listbox of 13 column. Even though i had formated the cells to currency "##0.00", the data that i input from textbox automatically gets converted to text into that pre-formated worksheet1, can u suggest any vba code so that the data when loaded into worksheet, it is in numerical format. Also when the same data captured into listbox should be in currency form ie "##0.00". I also have to perform calculation in the textbox before the data is loaded into worksheet and captured into listbox. Plz share ur contact number so that i can explain my doubts in depth. Regards

[@joshuacampbell5673]

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

[@Shalini-Dh]

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

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

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

[@adamkamundi9879]

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

[@maksudhasan8489]

Great content. I really appreciate. Thanks.

[@federicomejia5689]

non of these work in my case, but I see that it still is a text

[@mustafadarrar5880]

You're God sent. Thanks brother.

[@PresentationProcess]

Glad to help

[@sameerhadwal5204]

Thank you, it's great help

[@skbpanicker]

161 92 183 150 145 80 159 189 79 120 161 92 65 can you change these to numbers?

[@nidhikaim1284]

Thanks, well presented.

[@madhavtewary2421]

Extremely useful video sir

[@mcknites1981]

How about for 16 to 25 digits?

[@hayleywilson8266]

These tips didn’t work for me

[@ansh-singh]

I found valuable it helped me a lot

[@madleylim276]

what if all the 5ways do not work?

[@jodavila16]

Freat Video, Thanks!!