To display Mar 17,2008 as a custom format,you would type ____ in the Format Code: box in Excel.
A) mm dd,yy
B) mmm dd,yy
C) mmm dd,yyyy
D) mm dd,yyyy

Question

Quizplus · Accepted Answer

The correct format to display Mar 17, 2008 as a custom format is "mmm dd, yyyy", which will display the month abbreviation (Mar) followed by the day and year in four digits. Option A would display the month number instead of the month abbreviation, option B would display the year in two digits instead of four, and option D would not display the abbreviation for the month.

To Display Mar 17,2008 as a Custom Format,you Would Type