Help with Date format

D

davidian

I want to enter dates into a worksheet like this:
January 25, 2001

And i want to get excel to display the date with the following format:
1/25/01
I have tried using a date format from the format menu but it wont display
the date like i want! It will only display the date as I typed it in.

Thanks to anyone who can help. :)
 
J

Jason Morin

It appears you're typing the date into a cell formatted
as something other than General.

1. Delete the current contents of the cell.
2. Format > Cell > Number tab. Choose a date format.
3. Now key in the date into the cell.

HTH
Jason
Atlanta, GA
 
Top