how to dispaly date as Mon 2 Dec

S

Simon Le Page

Hello,
I need to create a forumula to change the date format from 2/12 to display
the day & date "Mon 2 Dec"
Thank You
 
M

mudraker

Simon

change cell format to ddd dd mmm

or for a formula format use =TEXT(A1,"ddd dd mmm"
 
D

Dave Peterson

You could just use a custom format:
ddd d mmm


Hello,
I need to create a forumula to change the date format from 2/12 to display
the day & date "Mon 2 Dec"
Thank You
Click to expand...
 
J

JudithJubilee

Hello Simon Le Page,

You can use a Custom Number Format:

Highlight the dates and choose Format + Cells + Number Tab.
Choose Custom and type the following into the text box:

ddd d mmm

Post back if you have any problems

Judith
 
R

Ron Rosenfeld

On Thu, 16 Mar 2006 16:36:30 -0800, Simon Le Page <Simon Le
Hello,
I need to create a forumula to change the date format from 2/12 to display
the day & date "Mon 2 Dec"
Thank You
Click to expand...

Obviously depends on the year, but if your date is a standard Excel date, then

Format/Cells/Number Custom Type: ddd d mmm


--ron
 
Top