View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default 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