How do i get th,nd,st,rd to display in Excel
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
|