Home/ Questions/Q 8917
Next
In Process
Computing Staff
  • 2
Asked: 2021-11-30T09:47:40+00:00 In:

Convert Date Ddmmyy To Dd/Mm/Yy In Excel

  • 2

How can I convert a date in format DDMMYY to DD/MM/YYYY in Excel 2002.

Thanks

Steve.

Share

    1 Answer

    1. Your looking for a Custom Format:
      On the Format menu, click Cells.
      On the Number tab, click Custom from the Category list.
      In the Type box overwrite what ever is in there, probably the word General
      with:

      DD/MM/YYYY

      click OK

      • 0