I'm an intermediate user so haven't been able to follow some of the answers to similar questions already posted. I have data in a column as follows:

1
1
2
2367
3
8

I want it to output how many times the character "2" appears, in this case, 2. Instead it keeps yielding 1, no matter what I try. The formula I've been working with is:

=COUNTIF(O5:O150,"*"&"2"&"*")

I've tried formatting the data as text or general. I've tried a million variations on whether the 2 and/or asterisks are in quotes, with and without ampersands.

I'm guessing that it's not treating the digits in numbers as text. How do I fix this?