I have a problem with cell-properties (numeric/text fields.) I don’t know to handle this.
For example.: One CSV-file I want to open with LibreOffice Calc have 25000rows and 20columns. Some columns are text fields and some other is numeric fields. When the file is imported into Calc, not all cells have the same type (text/numeric), in the same column. The biggest problem I have, is if I want to compare these cells with a column with only numbers. When the CSV file is imported with columns with only numbers, the numbers can contain spaces or decimal numbers with a point “.” (in Sweden we have the comma “,” as decimal sign). First, I usually clear the contents of the trash eg.
=STÄDA(RENSA(A1))(Swedish LO), and replace the decimal characters eg.
BYT:UT(A1;".",",")(Swedish LO), and finally use the instruction eg.
TEXTNUM (A1) (Swedish LO) to convert all cells to numbers. So far, there are usually no problems. The problems arise when these numbers (from cells consisting of formulas) are copied to the original cells. Now these cells contain valid numbers, but these cells are formatted as both numbers or text.
My wish is to be able to mark the entire column and choose the format “numbers”. It works if all cells in the entire column has text format, but it doesn’t work if some of the cells are numeric an some is formated as string. It is acceptable that cells that do not contain numbers do not change to numeric. (eg headers). But why doesn’t all other cells change from string to numeric?
What am I doing wrong?