Is it possible to turn M/F values into Boolean number format?

[LobaLuna]

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…)

[Wanderer]

@LobaLuna

I think that I can set Number format for this column as BOOLEAN.

The problem is: Formatting does NOT change data. So setting a number format for Text will be ignored (or to be more precise the fourth segment of the formatting will be used for text in a cell for numbers: @
.
So while it is easy to show something different for numbers, it is impossible to do the reverse for the cell. However: You may use the solution with =IF wich erAck gave in your linked thread in other cells:

Change Boolean to Yes/No instead of True/False

It occurred to me that the question was not about formatting but actually literally about interpreting a Yes or No word, or Si and No. So that would be the formula =IF( A1="Si"; 1; IF( A1="No"; 0; A1)) assuming content in cell A1, which if that is Si displays 1, if No displays 0, else the content of A1, or 0 if A1 is empty.

[LobaLuna]

You are totally right!

What a misconception I had!

Yes, I’ll change according to erAck. Thank you!