Forums

Tradefair & Financials

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Martin Van Buren
09 Aug 10 14:46
Joined:
Date Joined: 08 Dec 05
| Topic/replies: 448 | Blogger: Martin Van Buren's blog
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.
Pause Switch to Standard View Spreadsheet question. Help please.
Show More
Loading...
Report Pastie August 10, 2010 12:41 PM BST
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
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com