I have found two previous answers which both say to use the “text to columns” entry in the data menu, but it does not work for me.
I have a .csv file which I opened and it looked fine at first so I began working in it.
However, now I discover that whenever a cell has a negative number, there’s a small “’” sign in the beginning of it which apparently isn’t really a character but an indication that the cell is text when it should be a number.
The problem seems to be that the cell is otherwise correctly formatted, so the only way I can get “text to columns” to do anything is to force it to find a delimiter and split the cell into two, but I don’t want that. The cell contents is correct, I just want it to understand that the “-” sign is a negative sign and not a dash and I see no option for that.