Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Home -> Number ->Format Cells

Memo to self: Many companies work with people from around the world. When you select a format that displays the names, it is clear whether 2/1/08 is April 2nd or February 1st.

Format Date and Time

3. You can format this column for date and time. Go to the Home Ribbon and click on the Number group.

 

 

Try it: Use the combo box to change the General format. The drop-down box shows some options. The Long Date format spells out the months.