2

In Excel, what is the process to convert the date format from 201904 to Apr-19?

edit

• date
• process
• convert

asked 2023-06-12 21:23:13 +0000

woof
21 ●1 ●1

edit retag flag offensive close merge delete

add a comment

2

answered 2023-06-12 21:46:02 +0000

bukephalos
21 ●4 ●3

1. Select the cells with the date format 201904.
2. Right-click on the selected cells and choose "Format Cells."
3. In the "Format Cells" dialog box, select "Custom" from the category list.
4. In the "Type" field, enter "mmm-yy" and click "OK."
5. The date format will now be changed to Apr-19.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss