Forum Discussion
Anlu42
Nov 14, 2025Occasional Reader
Excel interprets dates 12 and lowers as months
Hi
If I in any cell, without any adjustment of cell formatting, excel will interpret 15/8 as 15-aug, as it should but 4/8 is interpreted as 8-apr...
Is there any way to get excel to interpret this consistently correct, that is dd/mm = dd-mmm and not "IF dd=≤12 then dd is mmm and mm=dd" which is insane?
No RepliesBe the first to reply