Register now or log in to join your professional community.
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