Help with Date format

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formatting 2
Formatting Dates 1
Auto Cell Format Change from General to Custom Date 1
Date Formatting 1
Cell Format 1
Excel Vba to change displayed year automatically. 14
Change Default Auto-Fill-In month 4
sorting dates in a worksheet 3

Top