# Functions not working in Calc on CSV file

I have opened a CSV file in LibreOffice Calc 6.0.6 on MacOS 10.13.6 with the default settings in Calc. Column A has dates in the format "Oct 06 2018 07:20:24". Columns B-D have numbers. If I check the format the dates are considered "Text" and the numbers are considered "Numbers". I highlighted column B and selected "Insert Columns Left" and created a new blank column B next to the dates in column A which moved the three columns of numbers in columns B-D to the right to C-E. I tried to calculate the DATEVALUE function in new blank cell B2 from the date in cell A2 so I entered "=DATEVALUE(A2)" for the cell containing the text "Oct 06 2018 07:20:24" and the result in the cell was "=DATEVALUE(A2)". No calculation of the function "DATEVALUE" was performed. I then tried to calculate in cell B3 the sum of numbers in cells (C3,D3 and E3) and again the result was "=SUM(C3:E3)". If I go to column F and use the function wizard, the functions work. If I go to the inserted column B (cell B5) and use the function wizard for "=DATEVALUE(A5)" the function wizard shows the result as a number but "OK"ing the calculation results in "=DATEVALUE(A5)" and not a numerical value. Same for the "SUM" function. Checking the format for cell B5 I see it is "Text" so I change it to "Number" but the result remains "=DATEVALUE(A5)". None of the functions will calculate in the created column B.