Excel - 5 easy ways to identify numbers stored as text

[@pingpongau]

Excellent tutorial and I got what I need. Thanks a lot,😊

[@Will.Tru8]

Thank you Chris!

[@ChrisMenardTraining]

My pleasure!

[@petehuffman]

This was VERY helpful

[@ChrisMenardTraining]

Thank you!

[@naajishan2369]

Select the column data ALT+D+E+Enter+Enter+Enter helps convert the entire column to numbers - May be you missed that - your video was awesome I am much learned now with your thoughts

[@ChrisMenardTraining]

Thank you The keyboard tip is great!

[@jagbirjhajharia1115]

Fantastic job and waiting for the next video

[@ChrisMenardTraining]

Thank you! I'll have the video out on Monday or Tuesday of next week.

[@jagbirjhajharia1115]

@@ChrisMenardTrainingthanks for information

[@gregorytaylor2749]

Great tutorial! Thanks!

[@ChrisMenardTraining]

You're welcome!

[@IanRae-g8m]

A great explanation of issue Chris, but I am at a loss to understand why the numbers are changing to text in the first place? I only came across this issue when I moved into another office and used another computer. I just knew the functions did not seem to give the proper result. There are many videos about fixing the issue but none explaining why it happens in the first place. In your example why did you get 5 cells with text and all the others were numbers. Is there anywhere a default can be set to say it looks like a number, insert it as one? Considering spreadsheets are for manipulating numbers it would seem to be a smart option to have in the setup.

[@ChrisMenardTraining]

Here is my blog post on this topic. This question came from a PMBA student at the Terry College of Business at the University of Georgia. My blog post contains a link to the file I used also. The blog post link is chrismenardtraining.com/post/excel-5-easy-ways-to-identify-numbers-stored-as-text

[@ubaidillahmuhammad20]

good job. may i have a file?

[@ChrisMenardTraining]

chrismenardtraining.com/Files/DownloadFile.aspx?FUID=f0709444-621c-4953-9f01-df24671b0563