Date format

[Guest]

I would like to enter a date without having to enter -'s or /'s and have it
display mm/dd/yy. I know how to make this work for phone numbers but can't
seem to find the correct formatting for dates. Thank you.

 

[Dave Peterson]

Visit Chip Pearson's site:
http://www.cpearson.com/excel/DateTimeEntry.htm

And you'll find one way.

 

[David McRitchie]

when looking a Chip's page, note that you are changing
the value of the cell to a date. Dates are the number of
days past a reference point such as Dec 31, 1899.

Your formatting of a phone number did not change the
value of phone number and was just formatting. I would
suggest that you use text values for phone numbers,
they work out much better that way (in my opinion),
regardless of whether you left or right justify them.