Date Wont Change in Excel??!

  • Thread starter Thread starter laurahhh
  • Start date Start date
L

laurahhh

Hi, I have been trying to formate a list of cells to display in the
dd/mmm/yy format when you type a date in the 9/6/04 format, I have
tried applying this as a formula and also right clicking and changing
the format date to dd/mmm/yy and it wont change. In the greyed bar it
just leaves it as what ever i have typed, and if you click on different
formats in the date list it still stays the same in this bar. Any ideas?
 
Right click on the cell in question. Select Fromat cells, select Custom, not
date, select dd/mm/yy, and edit it to read dd/mmm/yy
 
Right click on the cell in question. Select Fromat cells, select Custom, not
date, select dd/mm/yy, and edit it to read dd/mmm/yy
 

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

Change date format in Excel footer 2
Date Format 3
Change Date 5
Month (MMM) from date (dd/mmm/yy) 1
I WANT TO CREATE A FORMULA USING DATES 8
Convert date to text 2
Date Format 2
date and time difference 19

Back
Top