Text numbers and letters

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Go to the top of the column and select the first cell in the column where a number is stored as text. Then press CTRL + SHIFT + DOWN ARROW to select the remainder of the column.

At this point, a 'Number Stored as Text' error box should be displayed next to the last cell at the bottom. Click the exclamation point and select 'Convert to Number'

Bingo, the entire column is now fixed.

- Moo