Apply built-in number formats from the format dropdown, then use the full Format Cells dialog tabs for number, alignment, font, border, and fill settings....use Select the target cell or range. Both the quick format dropdown...merge state for the selected range and is submitted separately...