Ordinal Number Format

[injanib]

Hello,

I have a number field on my bound forum. The form is used to only display the records. I don't use the form for entering new record. I do that running an Update querry from an unbound form. What I need on the number field is to show the number in ordinal format (1st, 2nd, 3rd, 12th, etc.). I need to do this on the unbound form as well, so that when I enter the number, it should show the number in ordinal format. And then the bound field on the bound form should also show this number in ordinal format. When I print reports, I need this field to be in ordinal format. I have to keep this field in Number data type because it is used in calculations within queries and forms.

How can I go about achieving this?

Thanks in advance.

[June7]

Write a custom function. Google: VBA ordinal number
Here is one article http://www.cpearson.com/excel/ordinal.htm

[injanib]

This worked perfectly. Thank you.