how to dispaly date as Mon 2 Dec

[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

[mudraker]

Simon

change cell format to ddd dd mmm

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

[Dave Peterson]

You could just use a custom format:
ddd d mmm



Simon Le Page wrote:
>
> 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

--

Dave Peterson

[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
--
Hope this helps


"Simon Le Page" wrote:

> 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

[wdjsxj]

cell format/define
ddd-d-mmm

“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

[Ron Rosenfeld]

On Thu, 16 Mar 2006 16:36:30 -0800, Simon Le Page <Simon Le
[email protected]> wrote:

>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

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

Format/Cells/Number Custom Type: ddd d mmm


--ron