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

[Graham S]

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

[Niek Otten]

Hi Graham,

See

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

--
Kind regards,

Niek Otten

"Graham S" <GrahamS@discussions.microsoft.com> wrote in message
news:F8A35936-5C72-4493-9F6D-464A4DE278B8@microsoft.com...
>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

[Niek Otten]

Hi Graham,

See

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

--
Kind regards,

Niek Otten

"Graham S" <GrahamS@discussions.microsoft.com> wrote in message
news:F8A35936-5C72-4493-9F6D-464A4DE278B8@microsoft.com...
>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