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....formats such as Normal , Plain Text , Number , Percent , RMB , USD...contains five tabs: Number , Alignment , Font , Border , and Fill...