Adding suffix to a number in excel

[Joywin.Madtha]

But for 11 to 20 the suffix will be “th”
So that’s the condition
It will remain same for higher order numbers also
So if last 2 index had 11 to 20, we should add “th” suffix
How can this be implemented

Thanks @Palaniyappan

[Palaniyappan (Forum Leader)]

@Palaniyappan

If(row(0).ToString.Equals(“1”),row(0).ToString+“st”,
If(row(0).ToString.Equals(“2”),row(0).ToString+“nd”,
If(row(0).ToString.Equals(“3”),row(0).ToString+“rd”,row(0).ToString+“th”)))

then this would be fine till 20
@Joywin.Madtha

and if we are going beyond 20 till 100
If(row(0).ToString.Endswith(“1”),row(0).ToString+“st”,
If(row(0).ToString.Length.ToString.Equals(“2”) AND
row(0).ToString.SubString(0,1).Equals(“1”), row(0).ToString+“th”,
If(row(0).ToString.Endswith(“2”),row(0).ToString+“nd”,
If(row(0).ToString.Endswith(“3”),row(0).ToString+“rd”,row(0).ToString+“th”))))

Cheers @Joywin.Madtha

[msan (Michel SAN)]

Hi,

The switch activity should do the trick