Formatting Dates

D

davidian

I want to enter a date in text as in:
January 25, 2001

And then i want Excel to display it as:
1/25/01.
When i tryed to format the cells the date is displayed as I have typed it in.
Can anyone help me do this?
 
D

dandigger

Select all the cells you want in this format, right click, Format Cells, on
the Number tab, select 'Date,' then '3/14/98' as the type. Then click OK.
When I do this, and enter 'January 25, 2004, the cell changes it to 1/25/04.
 
Top