Tradefair & Financials
There is currently 1 person viewing this thread.
09 Aug 10
14:46
Joined:
Date Joined:
08 Dec 05
Hello.
I wonder if somebody might be able to answer the following question for me please?
Once a formula has returned an answer to a cell, is there any easy way to then FORMAT that answer into an ordinal number - like formatting a 3 into 3rd, a 15 into 15th, a 22 into 22nd etc etc?
It is very easy to do something similar with currencies, ensuring a 33 reads as £33.00 for example, but I cannot find the ordinal equivalent.
Thank you very much.
I wonder if somebody might be able to answer the following question for me please?
Once a formula has returned an answer to a cell, is there any easy way to then FORMAT that answer into an ordinal number - like formatting a 3 into 3rd, a 15 into 15th, a 22 into 22nd etc etc?
It is very easy to do something similar with currencies, ensuring a 33 reads as £33.00 for example, but I cannot find the ordinal equivalent.
Thank you very much.
sort by:
Show
per page
Replies: 1
|
By:
http://www.eggheadcafe.com/software/aspnet/34049902/how-do-i-format-numbers-to-ordinal-ie-1st-2nd-etc.aspx
http://www.cpearson.com/excel/ordinal.htm |