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....Percent , RMB , USD , EUR , Date , Time , Date time , and Duration ...for Date and Time , it selects one of the predefined date/time...