My Sanity: Zeros being removed when code run?

[Mr Denove]

Please help before the long sleeved jacket comes. A user updates a file and it shows a timestamp of 2022 and the zeros are removed from part of the file.
There is code to remove zeros but only in one column which is far removed from where the data goes missing.
I did get them to insert =Now() into a blank excel and it showed the correct date (same as in the timestamp).

If i run the update everything is fine and correct.

Ive never seen this before, can anyone please explain why the other person is experiencing this types of errors?
Thank you in advance.
Mr D

 

[Mr Denove]

No given how erratic our systems are i decided against it. And the file in question only contains vba to stop ctrl d in the sheet which i dont always run.

 

[MARK858]

Just wondered as I had the same issue since the update and had to reset the calculation on the Personal workbook (as it was the first workbook opening), but as you don't have one then that is no help to you.

 

[Mr Denove]

You had an update that caused issues?

 

[MARK858]

Happened at the same time as the Windows 10 update so I assume it is related. I haven't had any other issues.
Normally the calculation settings are dictated by the first workbook opened in a session which is why I needed to reset the personal workbook.