Hi Mike,
Here's a formula that will do the job:
=IF(OR(MOD(DAY(A3);10)>3;MOD(DAY(A3);10)=0;DAY(A3)-MOD(DAY(A3);10)=10);DAY(A3)&"th";DAY(A3)&CHOOSE(MOD(DAY(A3);10);"st";"nd";"rd"))
A little wordy, but gives the result you want.
tc
mike scott wrote:
On 9 Jun 2005 at 11:19, G. Roderick Singleton wrote:
...
One of the niggles I have with ooo is that there isn't (or more
accurately, I've not found) a way of formatting the day as "1st",
"2nd", "3rd", "4th", etc. instead of the bare number
....
Why not write a macro or use conditionals to do this?
Because that sounds cumbersome, and anyway I wouldn't have a clue how;
the return on the effort for one person to do find out for himself how
to do this is tiny; so I make do.
Don't worry - it won't put me off :-) I like OOo too much..........
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
