Computing Staff
  • 0

Convert Date Ddmmyy To Dd/Mm/Yy In Excel

  • 0

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