I'm opening a file in Excel, and it automaticaally changes a lot of the numbers to dates. How can I turn this off in the settings? I want to stop it. It is not happening to all files that I open but to some of them.
I did find that, which makes those numbers as text I think, but is there any alternative in the options maybe to disable something. Cause I am talking about several worksheet and files that I need to edit with apostrophe in each cell.
As an update toward the issue or problem. I got to notice that those numbers are in formula and can not add apostrophe to those cells. Please I require a solution as the suggested solution does not address my problem.