Forum Discussion
Solved
Dates Formatting Will Not Update When Changed
I am attempting to change the date format from the traditional U.S. date format (January 1, 2021) to MM/DD/YYYY (01/01/2021). When I select this, even under custom format, and apply to the selected c...
That means the values are probably not 'real' dates but text values that look like dates.
Try the following:
- Select the range with these 'dates'.
- Press Alt+F11 to activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type or copy/paste the following line:
Selection.Value = Selection.Value- With the insertion point anywhere in that line, press Enter.
- Close the Visual Basic Editor.
- Try changing the number format again.
That means the values are probably not 'real' dates but text values that look like dates.
Try the following:
- Select the range with these 'dates'.
- Press Alt+F11 to activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type or copy/paste the following line:
Selection.Value = Selection.Value- With the insertion point anywhere in that line, press Enter.
- Close the Visual Basic Editor.
- Try changing the number format again.
I don't understand why this works but wow does it ever! Thanks for posting this!