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.... Horizontal selects General , Left ,...than 0 , the dialog forces horizontal alignment to Left unless...