I would like to input dates in an Excel worksheet using Swedish format dd/mm, however Excel interprets this as mm/dd. That is, writing "7/8" in a cell is converted into Excel date (2019-07-08, YYYY-MM-DD). Other questions asked refer to changing mm/dd/yyyy to dd/mm/yyyy, which can be done through Windows settings, however I can't find a way of changing the mm/dd format.
A string based solution would work as suggested in some answers, however the reason I am asking is because I was manually inputting dates from a list of dates in dd/mm format, and it was annoying to have to twist every date in my head, or (while it would obviously work and be more robust) to have to set up e.g. two columns for month and day.