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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking Lists 3
How to set the day date in excel to display 1st, 2nd, etc...? 2
Counting or summing up a group of cells with dates as datas 3
Ordinal format 2
Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. 5
formatting numbers as 1st 2nd 12
Customized Format 7
Concatenate Numers / Text (Special) 2

Top