This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to make the entire date column the same long-date format, but only the ones on the right are changing. The short dates on the left seem to be locked or something, they won't change when I CTRL1 and change the format there either. Any ideas? I need the dates to all be the same for date-range type for some conditiona formatting and without it I can't. Thanks in advance!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You may try Selecting that column, text to column>Next>Next>Choose date >MDY. It will convert text to date value. Then format will work on it.
Hi, thanks for your reply. Unfortunately, after following the steps nothing changed when I pressed finish and selected Long Date for the column. If I click on one of the locked date entries for example, the type shows as "date" in the drop-down and no matter what I pick, they do not change. Any ideas?
Could you share a test file? Copy that column to a new file.
You may upload file in private message.