Format Date

M

Malcolm

Hi, all,
How do I format the date to show May, 2010? The closest I can get is May-10
from the drop down list.

Thanks,
Malcolm
 
G

Glenn

Malcolm said:
Hi, all,
How do I format the date to show May, 2010? The closest I can get is May-10
from the drop down list.

Thanks,
Malcolm
Click to expand...


Custom date format:

mmmm, yyyy
 
D

DaveC

right, format cells, in the general tab select custom, and if not already an
option to select from, type mmm, yyyy

If this helps, please press yes
 
M

Malcolm

DaveC, Hi,
Thanks dude.
Malcolm

DaveC said:
right, format cells, in the general tab select custom, and if not already an
option to select from, type mmm, yyyy

If this helps, please press yes
Click to expand...
 

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

How to make repeating drop-down lists? 2
Difficulty with compatibility mode and Track Changes 2
Printing Outline view - formatting lost 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Drop down lists in seperate columns 5
Clearing Fields in a Word Form 5
CONDITIONAL FORMATTING IN EXCEL 2010 1
Space at end of multi page list to accommodate new entries 1

Top