Want Numbers to display in all caps

Discussion in 'iWork Forum' started by Lauditor, Feb 9, 2012.

  1. Lauditor
    Offline

    Lauditor iPF Noob

    Joined:
    Feb 9, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Ohio
    Ratings:
    +0 / 0
    We use the iPad and Numbers in auditing buildings for energy efficiency. How can we get Numbers to display in all uppercase no matter if the data is typed in as uppercase or not?

    Finding out how could really help us!

    Thanks.
  2. giradman
    Offline

    giradman iPad Super Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,543
    Thanks Received:
    882
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +954 / 0
    Hello and welcome to the forum! :)

    Well, I'm not sure how you are doing entries in the cells and whether you need to switch back and forth between text and numbers? But double tapping the caps key will put it set on 'caps lock' and all letters will remain all uppercase; however, if you are switching between cells w/ different properties then I'm not sure if there is a setting w/i Numbers for iPad to achieve your purpose?

    Hopefully, others may 'chime in' w/ further suggestions, and please post back if you find a simpler solution - good luck!
  3. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,881
    Thanks Received:
    2,248
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,689 / 1
    I don't know of anyway to force all caps formatting in a text entry cell.

    The best I can come up with is to use one of the small-caps fonts like Copperplate or Bodoni 72 Smallcaps. You can choose them using the Text option under the Cells tab when formatting a cell, or group of cells. Copperplate comes the closest to looking like simple all caps, even when there are capitals and small text.

    If the cell only has a few possible options you can format it as a Pop-Up menu instead, and enter all the menu choices in caps.

    You can force upper case text results in a formula cell by using the UPPER function.

Share This Page

Search tags for this page
all caps in numbers
,
all caps number
,
all caps with numbers
,

apple numbers all caps

,
can i force uppercase in apple numbers?
,
can i format a cell to all caps in iwork
,
how to capitalize numbers on ipad
,
iworks numbers csv capitalization
,

mac numbers all caps

,
mac numbers capitalize all letters
,
numbers format allcaps
,
numbers iwork capitalization rules
,
preventing ipad2 from jumping back and forth between numbers and letters