Cant format the number

Hi guys, normally i would select the option “Text to Columns” change the text from Standard to Us-English and then i could format my numbers like I always did.
But when I try it now, it changes back to standard and nothing happens at all. I dont have apostrophes or anything else in the number field. I try really everything and I cant change the numbers, only if I type them manually, but I guess thats not the point in using this program…

Pleas help, I’m really desperate…

Please tell what version, language and part of LO, which OS you are using.