Anyone looking for an actual answer to this problem - I found the way to do it in Excel:

In you Excel settings:  you have to enable Background error checking – for Numbers formatted as text,  then you will get an error on those cells, and can CONVERT TEXT TO NUMBER

https://support.microsoft.com/en-us/topic/you-cannot-convert-text-to-number-when-the-cell-contains-a...