![format cells dialog box launcher format cells dialog box launcher](https://docs.devexpress.com/WindowsForms/images/spreadsheetcontrol_formatcellsdialog_alignmenttab25971.png)
On the Number tab, in the Category box, select the Custom item. in the popup menu: On the Home tab, in the Number group, click the launch pad icon: 3. Type a decimal or a whole number into the cell.Ĭlick the dialog box launcher next to Number on the Home tab Right-click on the selection and choose Format Cells.
![format cells dialog box launcher format cells dialog box launcher](https://www.exceltip.com/wp-content/uploads/2013/07/img1273-345x300.jpg)
The format cells dialog box contains tabs to control formatting for Number, Alignment. In the Type list on the right, click the fraction format type you want to see. The tab corresponding to the group you used will be active in the window.In the Category list on the left pane, click Fraction.Click the dialog box launcher next to Number on the Home tab.
#Format cells dialog box launcher how to
How to display Numbers as Fractions in Excelįollow the steps below to display numbers as fractions in Microsoft Excel. This is sometimes referred to as a dialogue box launcher. The formatting of Excel functions comes with several options, such as up to one digit, two digits, three digits, halves, quarters, eighths, sixteenths, etc. One way is to use the arrows that we see in the lower right hand corner of each of these groups. In Math, a fraction definition is a numerical quantity that is not a whole number, but in Excel, fractions are a number format used to display the numbers as fractions instead of numbers.
![format cells dialog box launcher format cells dialog box launcher](https://3.bp.blogspot.com/--NaKoCnMn2U/TZjuYDTDbUI/AAAAAAAAAMM/erQQISax8bc/s1600/dialog-box-launcher.gif)
Have you tried to enter a fraction into your Excel sheet, but when you press enter, it turns into a serial, whole, or decimal number, and you have no clue what to do? In Microsoft Excel, you can convert a number into a fraction using the Fraction format. The launcher is a small downward-pointing arrow located in the bottom right corner of individual groups or boxes on the ribbon.