In OpenOffice when opening a csv file or when copying a column of data, normally numeric data is usually interpreted as text instead of as a number. As much as we change the type of column and add that we want it to be a number, they still do not interpret correctly . If we visualize one of the cells that have this problem we can see that a previous apostrophe is added to the number with which they are never interpreted correctly.
I have read several possibilities to solve the problem, from making a function in visualbasic, to using the replace function , but I have found a new way that solves it perfectly. The option is to open openoffice, select the whole column with numbers with apostrophes that we want to change, open the top menu and select the option Data-> Text to columns . a window will open with the import options, click on the column and change the field type from default to English (US), in this way it will be correctly interpreted and we will have a column with numbers.
