numbering

[kiwiora]

Can't for the life of me think what it's called, so can't give you a title lol.

But I have calculated the difference between two dates (year based) What i now need to do is append a phrase to the end based on the number.. i.e

1

2

22

23

55

would become

1st

2nd

22nd

23rd

55th

how can i do a calc based on if it ends with

"1" insert "st"

"2" insert "nd"

"3" insert "rd"

"4 to 20" = "th"

21 insert "st"

22 insert 'nd"

23 insert 'rd'

24 - 30 = "th"

and so on

The range will only be 1 - 40

[Vaughan]

Ordinal numbers.

There was huge mega post on this subject a couple of months ago, perform a search on the Forums for it.

I know I posted a couple of messages to it, as did BobWeaver and LaRetta.

[MoonShadow]

I think this is the one you're talking about, Vaughan. You and Bob were rocking and rolling on it - Comment too!!

Numbers with text endings

[Vaughan]

Moonshadow: give LaRetta some credit too... she was really kicking some bottom!

[kiwiora]

Thanks guys. I tried searching but couldn't think for the life of me what phrase to use lol.

[MoonShadow]

I certainly didn't mean to forget anyone from my mention of that post, Vaughan, and apologies if it seemed that way. Besides, how COULD I forget LaRetta??

They say asking the right questions is the first half of all good solutions and she certainly is brimming with questions.

kiwiora, I have struggled with phrasing and searching myself at times. It's like trying to look up a word spelling in the dictionary but how can you look up something you can't spell? It's a dichotomy.