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.

author

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.

author

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

image

Customer Replay

Correct.
It happened on my Dell as well

author

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
author

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.

author

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.

author

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

Customer Replay

Nothing as of now, appreciate your help!

banner 6
author

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

https://imagedelivery.net/cT5c9Z7JJOphL0SI-n4Eyw/3c08550c-54df-4634-cdd2-c582619f3a00/width=80
Our expert Anton is online and ready to resolve your issues
993 resolved issues
Share on:
Copy to clipbord
Was it helpful?

Get answers until you're satisfied

/images/experts/tech/DannisK.webp
/images/experts/tech/StacyS.webp
/images/experts/tech/BorisP.webp

14 verified experts are online now

Artie K.

Expert's Assistant

Artie K.
Ask your question here

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