Get instant live expert help on I need help with excel number stored as text

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am formatting a column of number/letters to be stored as text. A formula relies on a vlookup with this column being used as the first criteria. It should work fine however I must go into each cell in the column, hit F2, then hit enter for the formula to identify it is stored as text. Is there an easier way to do this for the entire column since it is thousands of cells?
Solved by T. C. in 14 mins
I need to be able to convert one set of numbers that are labeled as UPC into another number labeled as an Item Number. Every time i type the UPC number it comes up as a stored Item number. UPC=Item Number
Solved by C. H. in 17 mins
Recently downloaded Office 2013 to laptop using m Windows 7.0. Am having lot of difficulty using Excel 2013. Numbers in cells is automatically being stored as text rather than as numbers so none of the calculations work. How can you help? Gail Farr 215-510-4338
Solved by F. Y. in 18 mins
Hi how do I import Excel data into my Power BI file when it is stored as a connection-only query? Thanks
Solved by A. L. in 30 mins
I want to write number text into an excel cell on my samsung galaxy tab s4 and have it recognised as a number and added into the formulas I am using
Solved by O. Y. in 28 mins