if you have 2007 type all the data 1 2 3 8
and if there is several 1 and 3 and whatever
on the home tab you see find and replace
a window pops us select find 1 and replace with 1st and repeat
easiest way i can think little time consuming though
don't know much about your sheet

"Bob Arnett" wrote:

Is there any way to display numbers in the mode of:
1st
2nd
3rd
4th
etc. ?