Excel changes my Date
Hi, I’m using Microsoft 365 and in excel when I try to type in a date e.g 01012014 excel changes it to 28/10/4670. I have formatted my cells to short date, I have also gone into advanced excel options to ensure that the box isn’t ticked for “use 1904 date system”. I just want to be able to type in a date and the system will automatically put it into the format that I have selected for the cell and keep the correct date. Eg I type 01012014 = excel to populate the cell like 01/01/2024. I have googled and looked into this community page but can’t seem to find the answer that I’m looking for, can anyone help please?
Hi, I’m using Microsoft 365 and in excel when I try to type in a date e.g 01012014 excel changes it to 28/10/4670. I have formatted my cells to short date, I have also gone into advanced excel options to ensure that the box isn’t ticked for “use 1904 date system”. I just want to be able to type in a date and the system will automatically put it into the format that I have selected for the cell and keep the correct date. Eg I type 01012014 = excel to populate the cell like 01/01/2024. I have googled and looked into this community page but can’t seem to find the answer that I’m looking for, can anyone help please? Read More