Convert Text to Numbers or Numbers to Text

This video covers how to convert or change text to numbers using several methods. If you want to recode text to numbers (or vice versa) without using any VBA, these are some of the easier ways to do it. By default text is left aligned and numbers are right aligned in the cell, so you'd need to be aware of this. There are a couple of functions (or formulas) you can use to perform the change. Converting letters to number has never been easier! Also how to convert or change numbers to text using some different methods, so if you want to learn to fix numbers stored as text, you'll see it here too.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[charleskearney]

I liked your video. I liked the fact that you showed several ways to convert from text to numbers. Great Job.

[rainbowinbahrain]

Pretty I work with huge data bases and these simple steps will save me precious time...God bless you!

[TheCashcows]

Bow to Mr. Doug H. I finally solved my problems with your video. Thanks.

[kkadade]

Thanks so much. The Data>Text to Column option saved me a lot of time today.

[clareanthony]

unhelpful. i wanted to convert a word (criteria in a questionnaire) into a number so i could total up a score.

[ElitePokemonTrainer]

Thank you for this video. It will make my Excel so much easier!

[asaldana]

Thank you for providing a clear list of alternatives for both text to number and vice versa. Great, great video. Thank you!

[iliasz.]

I needed this! Perfect video. Thank you Doug.

[TheArtOfCreativity]

Hi Doug,

THANK YOU, so very much! Your explanations were the ONLY one's that work!

[roamingalone]

Thanks so much. This video helps me a lot with my work.

[sarahdyah]

ur so helpful in my hopeless time. God Bless U !!! :")

[ndelpurg]

please more excel videos simple and to the point excellent teacher !

[Rokinso]

Thank you very much for this useful video!

[wendyflannery]

I agree with Clare Anthony. I wanted to change words into numbers for a total.

[kittykarn]

Doug, Please explain  the row "edit in cell", does it work? I'm not sure.

[marshalljackson]

Well explained, with multiple examples. Great job! And thank you.

[SeekerShady]

Thanks for the post it helps me a lot.

[maimako]

Do you know how can I add the formula in excel, example- fricx?Thank you

[accuvationgroup]

Hey Doug how to get that smart tags in MacBook excel

[arimanoramiri]

Really don't believe this. I been looking for so long bro. Thanks