Discussion in 'Computers, Hardware, and Operating Systems' started by N3DT, Oct 26, 2019.
Are you including the (frozen) Header row to dictate the column of values you want to sort by?
I know about the column thing. But what it ended up being was some web page data that did not copy/paste into Excel correctly. But I could import it with the import wizard. Then it worked. The numbers copied/pasted from the web page into Excel were not 'numbers', I really don't know what they were, hence the problem with not being able to use the 'numbers' in formulas. Excel is not like some of those old programs you could 'reveal codes'. Or at least I don't know how to 'reveal codes' in Excel.
Have you analyzed individual cell properties to see if they are protected or locked under another formatting?
Are there any colored triangles in the upper right corners of the cells in question?
I did try unlocking things and there were no warnings. Anyhow I figured out how to avoid it. Much easier just to import it right the first time than to worry about the formatting and try to straighten it out.
On the Data tab the "Text to Columns" function is the best thing for converting text data into numbers.