D M wrote:
Hi ~I want to display the date in the cell as follows: "1st May 2008". I have set the formatting of the cell to "dd mmm yyyy". Is there an easier way to do this without creating a macro?Denny.
You can use conditional formatting. Directly apply a date format containing "th", and make conditions like "OR(DAY(A1)=1;DAY(A1)=21;DAY(A1)=31)" for the other formats.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]