Display the Style dialog box.
Display the Cells dialog box. (Note that you must use the 1 key above the keyboard, not on the keypad.)
Apply the General number format.
Apply the Currency format with two decimal places (negative numbers in parentheses).
Apply the Percentage format with no decimal places.
Apply the Exponential number format with two decimal places.
Apply the Date format with the day, month, and year.
Apply the Time format with the hour and minute and AM or PM.
Apply the Number format with two decimal places, (exclamation point) thousands separator, and minus sign (–) for negative values.