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

How to Convert Text to Numbers in Excel - learn how to correct this very common Excel issue with 5 different methods. Such issues usually occur when you copy numbers from another type of document (Word or Notepad etc.)
What is covered in this Excel tutorial:
==============
00:00 Text Vs Numbers Format in Excel
01:31 Number Test
02:09 5 Ways to Convert Text to Nos
02:25 How to Use Smart Tags
02:51 How to use the Text to Columns feature
03:38 How to use Paste Special option
04:14 How to use Value function
04:41 How to use Replace comma

Sign Up for Complete Excel Foundation Course:

#ramgopalexcel

[sylverebryan]

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.

[NeelB]

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!

[davida]

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

[Boerikoe]

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

[deafdogdesign]

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

[joshuacampbell]

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

[karilockhart]

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!

[azman]

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

[erick.rodrigues]

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

[AnilSingh-mjlj]

Brief Video but Very Clear and Helpful!

[markb]

Bravo! Very clearly presented. It helped me a lot.

[noorifayaz]

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

[adamkamundi]

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

[yeshosingh]

Excellent tutorial - clear and to the point .

[swamy]

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

[sherishahmir]

Thanks for the solution, perfectly work out.

[paulclegg]

Thanks for a very comprehensive video. Worked a charm.

[genakjain]

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

[radhakv]

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

[izzyr]

Very clear and to the point - thank you.