Posted to microsoft.public.excel.worksheet.functions
|
|
how do I format numbers to ordinal i.e. 1st, 2nd etc
Hi,
Look here
http://www.cpearson.com/excel/ordinal.htm
Mike
"chieflx" wrote:
I am trying to use number format to present sightings in ordinal sequence. I
need to enter multiple sightings in one cell so I would like to be able to
type 1, 2, 3, etc. and it to appear as 1st, 2nd, 3rd etc.. I am not sure how
to set this up or even if it can be done but any help would be gratefully
received.
Many thanks
Chieflx
|