Updated: March 21, 2023
78 Views
Was it helpful?
author
by Anton Khomyk
Tech Expert & Writer
993 resolved issues

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

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.

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

image

Customer Replay

Correct.
It happened on my Dell as well

To stop cell date changing please follow these steps:

  1. Click on the cell you wish to lock.
  2. To open the Format Cells pop-up window, navigate to the "Home" tab in your Excel
    spreadsheet.
  3. To do so, select "Format" from the right-hand menu.
  4. 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.

banner 3

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.

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.

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

Customer Replay

Nothing as of now, appreciate your help!

banner 6

Thank you for chatting with us today, *****!
We are available 24/7, you can refer your questions anytime. Have a nice one!

Get answers until you're satisfied
14 verified experts are online now
Expert's Assistant
Ask your question here
Share on:
Copy to clipbord
Was it helpful?
Howly expert is ready to help you with your Windows problem

No comments yet...

What about starting a discussion? Be the first to share your thoughts!

Write a comment

We use cookies to improve your browsing experience on our site, show personalized content and targeted ads, and analyze site traffic.
More info