Excel Excel - Can the date format dd-mmm-yyyy display the month in upper case?

B

beccysmum

Joined
Oct 28, 2010
Messages
1
Reaction score
0
Hi all

I'm trying to find out if there is a way to display a column of dates in Excel as DD-MMM-YYYY (ie 01-JUL-2010). The standard formats only capitalise the first letter and it's driving me crazy!

Any advice will be gratefully received :)
 
EvanDavis

EvanDavis

Silly Fool
Joined
Jun 20, 2010
Messages
5,299
Reaction score
681
Welcome to the forum
happywave.gif


Try this
 

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

Returning the month (mmm) from cell in date format dd/mm/yyyy 1
Excel How to change the "Short Date" format in Excel? 4
Forcing a date entry format of dd/mm/yyyy 1
Month (MMM) from date (dd/mmm/yy) 1
How to enter a date in DD-MM-YYYY format 2
Counting Occurrence of a Value within Cells 1
Excel is seeing the date as dd/mm/yyyy 4
How to show imported field as date format DD-MMM-YY 2

Top