/VBA/Excel vba get ordinal number from cardinal number

Excel vba get ordinal number from cardinal number

Function Ordinal(n)
  Ordinal = n & Evaluate("IF(OR(--RIGHT(" & n & ",2)={11,12,13}),""th"",IFERROR(CHOOSE(RIGHT(" & n & "),""st"",""nd"",""rd""),""th""))")
End Function

Source: stackoverflow.com

Similar codes

0 vote122 views1 answer
Vba html document reference
VBA
0 vote136 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote120 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote133 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote124 views1 answer
Excel vba convert cells address
VBA
0 vote116 views1 answer
Vba len variant
VBA
0 vote119 views1 answer
Vba leading zeros in string
VBA
0 vote120 views1 answer
Vbscript abs
VBA
1 vote121 views1 answer
Vba date to unix timestamp
VBA
1 vote117 views1 answer
Vba declare api 64 bit 32 bit
VBA