How to keep away from converting a cell into date format. when is a date enter the cell converted into date format even if a number is entered?

you need sometimes to remove all the format applied then start from the beginning.

simply select that cell as a text.

you can change the format of that cell before you type any information in it, or you can seperate the information inside the cell using the Dot (.) mark