Hi,

I am trying to get the date, entered as 06/04/2002 to display as Saturday
6th Apr 2002

I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d mmm
yyy

What do I enter in the Custom category of the dialogue box that opens when I
go to FormatCells?

I would like to have the "th","st","rd","nd" displayed, by entering
something similar to "dddd d mmm yyy" in the custom category of the format
cells dialogue box.

Thanks,

Phil

http://www.cpearson.com/excel/ordinal.htm looks a good starting point.
--
David Biddulph

"Phil" wrote in message
...
Hi,

I am trying to get the date, entered as 06/04/2002 to display as Saturday
6th Apr 2002

I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d
mmm
yyy

What do I enter in the Custom category of the dialogue box that opens when
I
go to FormatCells?

I would like to have the "th","st","rd","nd" displayed, by entering
something similar to "dddd d mmm yyy" in the custom category of the format
cells dialogue box.

Thanks,

Phil

Hi Phil,

See

http://xldynamic.com/source/xld.RANK.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Phil" wrote in message ...
| Hi,
|
| I am trying to get the date, entered as 06/04/2002 to display as Saturday
| 6th Apr 2002
|
| I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d mmm
| yyy
|
| What do I enter in the Custom category of the dialogue box that opens when I
| go to FormatCells?
|
| I would like to have the "th","st","rd","nd" displayed, by entering
| something similar to "dddd d mmm yyy" in the custom category of the format
| cells dialogue box.
|
| Thanks,
|
| Phil

So I ask a question in regard to your last post and you re-post the whole
thing
as a New post, totally ignoring the replies that you got the last time.

At least you've posed the question clearly and consisely, unlike the last
vague request.

I still don't know how it's done, but a couple of replies seem to have an
answer.
Lets hope you read them.

Steve


On Wed, 15 Nov 2006 08:35:02 -0000, Phil
wrote:

Hi,

I am trying to get the date, entered as 06/04/2002 to display as Saturday
6th Apr 2002

I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d
mmm
yyy

What do I enter in the Custom category of the dialogue box that opens
when I
go to FormatCells?

I would like to have the "th","st","rd","nd" displayed, by entering
something similar to "dddd d mmm yyy" in the custom category of the
format
cells dialogue box.

Thanks,

Phil

Is there no easy way of typing something straight into the custom part of
Format Cells. These ways involve formulas, instead of a symply cell
formatting.

"SteveW" wrote:

So I ask a question in regard to your last post and you re-post the whole
thing
as a New post, totally ignoring the replies that you got the last time.

At least you've posed the question clearly and consisely, unlike the last
vague request.

I still don't know how it's done, but a couple of replies seem to have an
answer.
Lets hope you read them.

Steve


On Wed, 15 Nov 2006 08:35:02 -0000, Phil
wrote:

Hi,

I am trying to get the date, entered as 06/04/2002 to display as Saturday
6th Apr 2002

I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d
mmm
yyy

What do I enter in the Custom category of the dialogue box that opens
when I
go to FormatCells?

I would like to have the "th","st","rd","nd" displayed, by entering
something similar to "dddd d mmm yyy" in the custom category of the
format
cells dialogue box.

Thanks,

Phil

<Is there no easy way of typing something straight into the custom part of Format Cells

No.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Phil" wrote in message ...
| Is there no easy way of typing something straight into the custom part of
| Format Cells. These ways involve formulas, instead of a symply cell
| formatting.
|
| "SteveW" wrote:
|
| So I ask a question in regard to your last post and you re-post the whole
| thing
| as a New post, totally ignoring the replies that you got the last time.
|
| At least you've posed the question clearly and consisely, unlike the last
| vague request.
|
| I still don't know how it's done, but a couple of replies seem to have an
| answer.
| Lets hope you read them.
|
| Steve
|
|
| On Wed, 15 Nov 2006 08:35:02 -0000, Phil
| wrote:
|
| Hi,
|
| I am trying to get the date, entered as 06/04/2002 to display as Saturday
| 6th Apr 2002
|
| I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d
| mmm
| yyy
|
| What do I enter in the Custom category of the dialogue box that opens
| when I
| go to FormatCells?
|
| I would like to have the "th","st","rd","nd" displayed, by entering
| something similar to "dddd d mmm yyy" in the custom category of the
| format
| cells dialogue box.
|
| Thanks,
|
| Phil
|

Annoyingly it seems there isn't - pity

Steve

On Wed, 15 Nov 2006 13:21:02 -0000, Phil
wrote:

Is there no easy way of typing something straight into the custom part of
Format Cells. These ways involve formulas, instead of a symply cell
formatting.

"SteveW" wrote:

So I ask a question in regard to your last post and you re-post the
whole
thing
as a New post, totally ignoring the replies that you got the last time.

At least you've posed the question clearly and consisely, unlike the
last
vague request.

I still don't know how it's done, but a couple of replies seem to have
an
answer.
Lets hope you read them.

Steve


On Wed, 15 Nov 2006 08:35:02 -0000, Phil

wrote:

Hi,

I am trying to get the date, entered as 06/04/2002 to display as
Saturday
6th Apr 2002

I have got as far as Saturday 6 Apr 2002 with the custom format: dddd
d
mmm
yyy

What do I enter in the Custom category of the dialogue box that opens
when I
go to FormatCells?

I would like to have the "th","st","rd","nd" displayed, by entering
something similar to "dddd d mmm yyy" in the custom category of the
format
cells dialogue box.

Thanks,

Phil