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.... Type changes by category: for Number...becomes editable so you can type or select a custom format string...