Formatting a spreadsheet column to all caps

[metropical]

I’ve tried formatting a column from
/Format/Text/UPPERCASE.

But it doesn’t stay. next time I enter text, it is lower case until I change.
Am I using the wrong method for formatting text in a column?

[fpy]

How do I have a column (Calc) to be all caps?

Writer has the font effect Capitals. Not so Calc. But you can select a font that use all caps. E.g.: Perpetua Titling MT, Engravers MT, Algerian, Castellar, Felix Titling, Goudy Stout, Showcard Gothic, Stencil. Some are suitable for common text, and some are not. You can make a internet search for “free all caps fonts”. @erAck, Thanks for the dose of humor. Edit your question if you want to add more information; also can comment an answer (Add Answer is reserved for solutions)…

[metropical]

so even though the font I used (calibri) changes to upper, there is no way it’s gonna stick unless I choose a font that has all caps - effect? I’ve not heard the word effect used in relation to fonts.
None of the fonts you mention come up in Format Cells.

[EarnestAl]

Calibri font doesn’t support UPPERCASE in font features. It does however support Small Caps for both uppercase and lowercase.
You could either:

1. Create a style with Calibri and with Features set with Capitals to Small Capitals and Lowercase to Small Capitals ticked, or just enter Calibri:c2sc&smcp in the Font name. You might want to increase font size
2. Direct format the column: select the column and enter in the font name box Calibri:c2sc&smcp

CalibriSmallCaps.ods (8.5 KB)