Help with Excel Spreadsheet

So I’ve starting using MT5 this time around. And I’ve gone downloaded data into excel as a .csv file.

When I open the file I see the following text.

“2020.03.03 02:00:00 540.01 541.01 538.88 539.13 193 0 75”

No biggie. I simply use “=MID()” to extract the data (date, time, open, high, low, close, volume) into columns for analysis.

However when I then use a function like “=MAX()” to analysis each array (column), (this case maximum value) it returns zero.

I like to think I’m pretty good in excel but this has got me stumped, any help???