I need to have a date stop changing from, for example, January 2022 to Jan-22. Note sure how to do so.

Anton Khomyk

Hello, thank you for using Howly.
What device do you want the date to stop changing at?

Customer Replay

An HP Elitebook.
But it seems like it is a function of excel that automatically requires a certain date setting that they provide to choose from and I need to re-create a report verbatim that they have "January 2022" and so on as their dates.

Anton Khomyk

Ah, okay, so the root of the problem is in Excel, right?

Customer Replay

Correct.
It happened on my Dell as well

Anton Khomyk

To stop cell date changing please follow these steps:

Click on the cell you wish to lock.
To open the Format Cells pop-up window, navigate to the "Home" tab in your Excel
spreadsheet.
To do so, select "Format" from the right-hand menu.
From the drop-down menu, select "Lock Cell."
Or you meant the whole document in Excel?

Customer Replay

I just need to lock 12 cells.
But it did not seem to work.

Anton Khomyk

Have you tried to lock every cell or everything at once?

Customer Replay

I locked the cell, but it seems like locking only disables outside edits into specific cells. It doesn't seem like it makes them resistant to automated changes within excel.
I think I got it.

Anton Khomyk

Okay, keep me posted if something goes wrong.

Customer Replay

Will do.
Good, was able to get it.
We can go ahead and close it out.

Anton Khomyk

I was glad to help! Do you have any additional tech-related questions?

Customer Replay

Nothing as of now, appreciate your help!