In Excel, I want to get a leading zero on a numeric day and month entries for sort.
I have separate columns for year, month and day.
I have tried many formats without success. If I format as text with a leading zero I get a warning that a number is stored as text and the sort is incorrect.
Does anyone have a suggestion?