Date Wont Change in Excel??!

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

kassie

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 10
Complex date VBA - insert a certain weekday 8
Date Format - simple question 1
Change Date 6
Date Format 3
Month (MMM) from date (dd/mmm/yy) 1
date and time difference 19

Top