Forum Discussion
CHANGE THE ORDER OF A CELL DATA NUMBER
IF I WANT TO CHANGE THE ORDER OF A CELL DATA NUMBER SEQUENCE AUTOMATICALLY FROM 123/09/2022 TO 2022/09/123 HOW DO I DO IT
2 Replies
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
- Assuming the cell is "text" and it is in cell: A1, the formula to convert 123/09/2022 to 2022/09/123 would be:
=Right(A1,4) & mid(A1,4,4) & Left(A1,3)
Good Luck!
