Forum Discussion

Copper Contributor

Aug 17, 2022

Solved

How to make the format of date from 1/1/2022 to 2022/1/1?

How to make the format of date from 1/1/2022 to 2022/1/1?

Thank you for your feedback.

SergeiBaklan
Aug 18, 2022
SusanHung

It looks like you have texts in column A, not dates. If so, you may convert them to dates by selecting column A, Data->Text to Columns, on third step of the wizard select Date and MDY.

7 Replies

Harun24HR
Bronze Contributor
Aug 17, 2022
SusanHung Use custom cell formatting. Right click on cell then choose Format Cells. Use yyyy/M/D to custom number format. See below screenshot. If you want to show result on different cell by formula then can use TEXT() function like.
=TEXT(A1,"yyyy/M/D")
- SusanHung
  Copper Contributor
  Aug 17, 2022
  Harun24HR Thanks for your promptly reply. In fact, I would like to sort the A column by date but it can't distinguish that 11 (Nov.) is more than 5, 4 and others. Do you have any comments on this. thanks.
  - Harun24HR
    Bronze Contributor
    Aug 17, 2022
    SusanHung Because TEXT() function return string data as text. So you can sort then. You can try SORT() function then use text like
    =TEXT(SORT(A1:A8,,-1),"YYYY/MM/DD")

Resources