00:00hi everyone in this video i will guide you how to turn text into numbers like a pro
00:06in excel numbers are stored as text and you will often see as a green triangle in the corner of
00:13the cell so select the cell click on this icon and convert your number and this is where you can
00:22easily convert text into numbers so this is a short term solution if you have a big data
00:29so it is extremely difficult and to convert text into numbers so how you can do that with the
00:35formulas you need to type is equal to type value open the bracket select the cells close bracket
00:47hit enter and drag it and that's it you can see that all the text values are converted into
00:55numbers another way is that type one in any of cell then copy ctrl c select all the data set and
01:08right click click on the paste special and here you need to click on the multiply and divide and hit
01:17okay and now that's all the all text values are converted into numbers another way is that
01:26copy all the data set go to the data and here click on text to columns
01:36click on delimited and click on next next and click on the finish and the values are converted into numbers
01:50so in this video you have learned how to identify numbers stored as text and use the convert to number
01:57feature and also you have learned that how to use space special multiply by one
02:02and then how to use the value formula to fix the formatting issues
02:09so if you think this video is helpful please vote my channel thanks for watching
Comments