How to make date automatically display only day number and suffix (1st, 2nd, etc.)?

Published: 11/01/2019
How to make date automatically display only day number and suffix (1st, 2nd, etc.)?
Source: WEBAPPS.STACKEXCHANGE.COM

Title explains it. I need to know how to create a custom number format in which a cell would display only the date and suffix of a full date entered into the cell example: 1/05/2019 -> 5th I have accomplished this myself but I have to manually determine which day has which suffix and then add the suffix to the custom number format manually. Not a big deal but if this is possible, it would save som

Read more
Related news
Comment
FACEBOOK