Adjust Numbers Text For Free

First, the keyboard shortcut for editing a cell is F2 on Windows, and Control + U on a Mac. With Excel's default settings, this will put your cursor directly in the cell, ready to edit. You can also double-click a cell to edit.

NumbersSelect the cells or table you want to format.In the Format sidebar, click the Cell tab.Click the Data Format pop-up menu and choose an option: Number: Displays standard number formatting. Set the number of decimal places: In the Decimals field, type the number of decimal places you want to display.

NumbersSelect the cells or table you want to format, tap .Tap. to the right of Number.Tap a format (Number, Scientific, or Fraction). Tip: Tap the E key on the numeric keypad to enter numbers in scientific E-notation (for example, 1E+04).Set the number of decimal places and other display options.

Create a custom text formatIn the Format sidebar, click the Cell tab. Click the Data Format pop-up menu, then choose Create Custom Format. Type a name for your format, then click the Type pop-up menu and choose Text. In the text field, type text that you want to appear automatically in each cell that uses this format.

Align and justify textTap a text box or shape with text to select it; if you're working in a table, tap a table cell or select a row or column.Tap .Tap Text or Cell, then tap any of the alignment buttons.

Back when I used Excel you could easily do all the navigation and editing on a spreadsheet with the keyboard. I could navigate around with the arrow keys and hit F2 to edit a cell and start typing. In Numbers '09 I can navigate easily using the arrows then start typing to overwrite the contents of a cell.

Apply a custom number formatSelect the cell or range of cells that you want to format.On the Home tab, under Number, on the Number Format pop-up menu. , click Custom.In the Format Cells dialog box, under Category, click Custom.At the bottom of the Type list, select the built-in format that you just created.Click OK.