Format numbers (ie 1st, 2nd, 3rd, 4th, 22nd, etc)
 

I have a column of numbers which are the result of determining the number of
years between two dates. I need to display a formatted results (ie: 1st,
2nd, 3rd, 4th, 22nd, etc.). Is there a way to do this?

Any suggestions would be appreciated.
--
Thanks,

Graham S

Format numbers (ie 1st, 2nd, 3rd, 4th, 22nd, etc)
 

Hi Graham,

See

http://www.cpearson.com/excel/ordinal.htm

--
Kind regards,

Niek Otten

"Graham S" wrote in message
...
I have a column of numbers which are the result of determining the number
of
years between two dates. I need to display a formatted results (ie: 1st,
2nd, 3rd, 4th, 22nd, etc.). Is there a way to do this?

Any suggestions would be appreciated.
--
Thanks,

Graham S