Use a custom format in Excel to display easier to read millions ... Now, let’s try a custom format and see what happens: Select the data range and press [Ctrl]+1 to display the Format Cells ...