"I now use Excel 2016) whereby when I open a file I have already worked on (even same day) the format in cell is changing from ‘general’ to date. "
What is the cause of this problem and how can it be rectified?
It normally change format automatically if a value inside a cell match a certain Excel format logic.
Date is an example. even if you enter in a general format cell a "date", if the date value represent
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…