Date Formatting

[mpavlina]

How do you format a date field so that you don't need to
enter the '/' between the month, date and year? We are
getting the julian number when we enter a date. Thanks.

 

[Ali]

Format it as text.

 

[J.E. McGimpsey]

Check out:

http://cpearson.com/excel/DateTimeEntry.htm