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
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 some time.
This is what I am using as the custom number format for the -th suffix:
d"th". This works but there has to be a way to do it as I described above.