This tutorial would explain on how to convert a list of “text which represents numbers” to numbers. Calc-Basics Convert Text to Number in LibreOffice Calc
