why can't i change text capitalisation in a column? Only option is none for me.

If you need to change the actual value of the text in a cell to uppercase, as opposed to just how it is displayed, then keep in mind that you can use the UPPER function.

UPPER - Apple Support

To change an entire column you would add an adjacent column, in the first body enter the formula referring to the first body of the orginal column, and fill that formula down the new column.

Then, to "remove" the formulas select the cells in new column, command-c to copy, and Edit > Paste Formula Results.

Then delete the original column.

SG

Appears to be 'not an option' for text in table cells. I get the same result as you when a cell or the text in a cell is selected. The capitalization options list opens and can be applied to text in a Text Box in a Numbers document.

Numbers v 13.0

Regards,

Barry

Hi centurio7,

Select the text in the cell:

Regards,

Ian.

Hi Ian,

Good exploration!

Regards,

Barry

Thanks Barry 😉.

Ian.