Formatting Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

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
Help with Date format 1
Auto Cell Format Change from General to Custom Date 1
Date Formatting 1
Change Default Auto-Fill-In month 4
Why this paste result? 4
Date format 4
Formula not reading date format 3

Back
Top