Aug 02 2021 06:23 AM
Have an ongoing issue with Excel where it auto formats populated cells. Example I have client reports which are legal requirements for LOLER certification. If the serial is 07-0399 on the spreadsheet it will read correct once the cell is formatted to text. However when the spreadsheet is reopened Excel auto formats the cells to date again! There must be a way to stop this but even after speaking to Office365 support last year the only option we have been left with is either use the "get data" option in Excel or use Google Sheets which doesn't auto format any data,
Aug 02 2021 06:59 AM
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.