I have a list of coordinates but some of them does not have (.) in them.
so all i need to do is to search in each cell if there is the (.) and if not to go and add it in the 3 place of the cell.
i did find a way to form them and make the cells red, in order to go and do it manually, but we are talking about thousands of cells, so i am looking for a more automated way of doing it .
all cells have text inside and not number.
Looking forward for your reply.
thank you for your time reading it