|
Back to Excel Tips Index
Ordinal numbers are numbers that have
the number and either a "st", "nd", "rd", or "th" after it as in 1st, 2nd,
3rd, or 4th. To create this with a formula follow the the example
here.
· In cell B2 to cell B25 type 1
- 24
· In C2 insert the formula shown
below and copy down.
ex. =B2&IF(OR(--(RIGHT(B2,2))={11,12,13}),"th",IF(OR(--(RIGHT(B2,1))={1,2,3}),CHOOSE(--(RIGHT(B2,1)),"st","nd","rd"),"th"))
Back to Excel Tips Index |
