Hi all, first post.
I am trying to format a range of cells so that when a user enters a date as 12/21/23, it appears in the cell as 21-DEC-23. There is a number format that results in 21-Dec-23, but I am wanting the month in CAPS. I have tried to use a custom format of d-MMM-yy, but that doesn't work. All assistance is appreciated.
Alan
I am trying to format a range of cells so that when a user enters a date as 12/21/23, it appears in the cell as 21-DEC-23. There is a number format that results in 21-Dec-23, but I am wanting the month in CAPS. I have tried to use a custom format of d-MMM-yy, but that doesn't work. All assistance is appreciated.
Alan