where is the number dialog box launcher in excel

#Where is the number dialog box launcher in excel mac

Click the Font Settings dialog box launcher.ģ.

Select the numbers in a cell or cell range that you would like to make small numbers.Ģ. You can make small numbers in Excel outside the mathematical equations tolls through the Format Cells dialog box. Fill out the boxes with an appropriate number, then click OK. Click 'Script' from the 'Structures' group and select either superscript or subscript.Ĥ. Click on the 'Symbols' group and select the 'Equation' icon.ģ. Click the Insert tab in the main ribbon menu options.Ģ. You can achieve this through the Insert Equation method. To enter a small number to a number value can be tricky but manageable. Making a small number using the equation method It means you cannot use the results for any calculations. Remember, these keyboard shortcuts cannot be applied to numbers as this would convert numbers to strings. Next, press Alt + E to tick the Superscript checkbox. On your keyboard, press Ctrl + 1or Ctrl + Shift + F, which will open the Format Cells dialog box.ģ. Select the text or number you want to superscript on your worksheet.Ģ. When done, press the enter button and write the number you want to appear as a subscriptġ. Press Alt + B for the Subscript checkboxĤ. On your keyboard, press Ctrl + 1 or Ctrl + Shift + F for the Format Cells dialog box.ģ. Select your text by double-clicking on the cell or press F2 to enter edit mode.'Ģ. It is achieved through a combination of keyboard shortcuts.

#Where is the number dialog box launcher in excel mac

You can easily make small numbers in your Excel worksheet through your PC's or Mac keyboard. Making a small number in Excel using keyboard shortcuts

Making a small number using the equation method.Making a small number in Excel using keyboard shortcuts.