Not formatting, but take a look at
http://www.xldynamic.com/source/xld.RANK.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
Is there any way to Format numbers like this

1st
2nd
3rd
4th

etc, etc, etc


Thanks