May 23, 200520 yr 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
May 23, 200520 yr 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.
May 23, 200520 yr 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
May 24, 200520 yr Author Thanks guys. I tried searching but couldn't think for the life of me what phrase to use lol.
May 24, 200520 yr 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.
Create an account or sign in to comment