If you’re wondering how to convert text to numbers in Excel, this video shows you a quick way to do that.

In Excel, there may be errors in the formulas because the values look like numbers, but they do not add up or multiply. The reason for this happening is numbers formatted as text.

In addition, your cells can display an error flag, converting text strings into numbers by clicking the /”Convert to Number/” option. However, it is not effective, so this video shows you how to do it with a simple formula.

All you have to do is use the VALUE() function following the steps of this tutorial:

⇨ VALUE(text) – converts text values into numbers

I hope this video is useful to you and if you learn something new, please hit the like button so we can reach and help more people for free. ️

Timestamp:
00:00 Intro
00:11 Convert text to number
00:53 This is how you do it

RECOMMENDED VIDEOS/PLAYLISTS
Financial functions: https://www.youtube.com/watch?v=FrD2B_nEnSc&list=PLQHFVtY7qRavbgxjqGGE6t3TSlpToYztl&ab_channel=ExcelCogTutorials
Common errors: https://www.youtube.com/watch?v=cDBSxgH_WLU&list=PLQHFVtY7qRatNX2w9ov3B2On7FdJiniXG&ab_channel=ExcelCogTutorials
How to tutorials: https://www.youtube.com/watch?v=LZkMf8tMnDw&list=PLQHFVtY7qRaufg0mmtiP3NWvHJCo0WT07&ab_channel=ExcelCogTutorials
Regular functions explained: https://www.youtube.com/playlist?list=PLQHFVtY7qRasFz48oVe-4IbO-jQfY1_9v

Feeling generous? I like coffee.
https://www.buymeacoffee.com/cogwheel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.