I have a large dataset where one column has M or F (male or female) string values.
I think that I can set Number format for this column as BOOLEAN. This way I could operate in the column as if were numbers.
I see the post https://ask.libreoffice.org/t/change-boolean-to-yes-no-instead-of-true-false/19118, where my question is answered, perhaps, but I cannot figure out how to do it. Please, a word of advise.
I do not want to rewrite the column with search/replace (I know it’s feasible, but I’m exploring this possibility of working with the data as is…)