Forum Discussion
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 ...
It will depend on your compute date formatting settings. Change date formats to your computer from control panel and excel will automatically treat entered data as day, month & year based on that settings.