Adding Ordinal Notation To Dates In Excel
Key Takeaway: Ordinal notation can be added to Excel dates by using custom formatting codes in the cell format option. This allows users to display dates with suffixes such as “st”, “nd”, “rd” or “th” after the day number. Custom formatting codes for dates include a combination of symbols that represent different components of the…