Number Stored as Text

text is aligned to the left, number to the right
try to use Text to columns on column with the "numbers" and click Finish. Don't do anything else.

t2c.jpg

But if you want go thru ca. 100 files automatically you'll need vba so use Report Post in your 1st post and ask moderator to move this thread to appropriate Forum section.

There may be a VBA method to check multiple files for this, but that's way above my skill level.

You can locate those cells with Conditional Formatting (in addition to what Sandy suggested above about alignment, or if default alignments have been changed).
1. Select all the data on the sheet, starting with A1 (so, something like A1:CD2000).
2. Click Conditional Formatting → New Rule → Use a formula to determine which cells to format
3. Enter this formula:

Formula:

Please Login or Register  to view this content.

4. Choose some sort of highlight which will stand out - bright yellow or turquoise blue or similar.

You can change all the cells to numbers by doing this:
1. Select a blank cell and click Copy (or press Ctrl-C)
2. Select the range containing the cells with numbers stored as text
3. Click Paste → Paste Special
4. Choose Add and click OK.

This will add blank to all numbers, including those stored as text, which will have the effect of adding zero, so won't change them, but will convert them all to numbers. It won't affect text, but it will convert any TRUE/FALSE values to 1s and 0s. It will also change any dates/times to just numbers.
So be careful which ranges you apply this to!

Hope that helps a bit.

Up front, I don't have VBA skills so when I have an issue like this I do it with an old school way. If it spreads over several tabs of one workbook I highlight all the tabs, then use find and replace, find what >> 0, replace with >> 0, I do it 10 times with 0 through 9. No formulas needed, no VBA and it hasn't failed me yet.

Aardigspook's sounds intriguing and I'll have to note it to try it in the future.