Forum Discussion

vivienkong's avatar
vivienkong
Copper Contributor
Mar 06, 2023
Solved

changing numbers into date

I want to change the number 28022023 into 28/02/2023 format. Kindly advice how how to do it. The number is actually a transaction date provided from a statement. I want to format it into 28/02/2023 s...
excel
  • Patrick2788's avatar
    Patrick2788
    Mar 06, 2023

    vivienkong 

    Let's say the number is in A1:

    =DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))

    Then choose desired cell formatting for date.

  • vivienkong's avatar
    vivienkong
    Copper Contributor
    Mar 10, 2023
    Thank you Nikolino

Resources