Number stored as text

Hello - I'm sorry for beating a dead horse, but I've tried many ways to convert text to numbers, but none seem to work.

When I import my lab results, excel won't recognize the results as numerical values unless I manual change all the numbers. This is extremely frustrating when you have tons of results.

I've Tried:
VALUE function to convert numbers stored as text to usable values
convert numbers stored as text to values by multiplying the cells by 1.

I've attached a sample workbook of the issue.

I'd greatly appreciate any help and please note I'm a novice.

Thanks

Excel Problem 1.xlsx