Numbers uppercase

You can change the *display* of text to all caps this way:

Select the cells and choose Format > Font > Capitalization > All Caps from the menu.

That displays as all caps but doesn't affect the actual values in cells.

If you need to change the actual values in the cells you can use the =UPPER() function.

SG

Hi Morten,

The ALL CAPS format changes the display, but does not change the characters (the ACSII code for "a" remains at 97).

The UPPER function changes the characters (the ASCII code for "A" is 65).

Depending upon what further text formulas you have, the ASCII value may make a difference, especially if you export to another app. For example, does Excel recognise the ALL CAPS display from Numbers?

Regards,

Ian.

Hi Morten,

Morten Nielsen2 wrote:

Thanks for the "heads up".

If I export to PDF or Excel (.xlsx) it keeps the letters upper case.

Good to hear!

Regards, and thanks for your feedback and the gold star.

Ian.