lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have dates like the one below. I saw video on how to covert them using text2columns. So I used it and went to delimiter (unchecked all) then next page, I select Date, then select different date formats.
I got not consistent result. The only result was correct when I select YMD format. I have a feeling YMD is only one accepted because my date is for example 20211116 (which is yyyymmdd) so in Text 2 columns
I have to select YMD format to match my date. Am I right? By the way my computer/excel date is DD/MM/YYYY.
I have dates like the one below. I saw video on how to covert them using text2columns. So I used it and went to delimiter (unchecked all) then next page, I select Date, then select different date formats.
I got not consistent result. The only result was correct when I select YMD format. I have a feeling YMD is only one accepted because my date is for example 20211116 (which is yyyymmdd) so in Text 2 columns
I have to select YMD format to match my date. Am I right? By the way my computer/excel date is DD/MM/YYYY.
aadvanced - all.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
4 | Date | MDY | DMY | YMD | YDM | ||
5 | 20210111 | ####### | 20210111 | 11/01/2021 | 01/11/2021 | ||
6 | 20210206 | ####### | 20210206 | 06/02/2021 | 02/06/2021 | ||
7 | 20211011 | ####### | 20211011 | 11/10/2021 | 10/11/2021 | ||
8 | 20210809 | ####### | 20210809 | 09/08/2021 | 08/09/2021 | ||
9 | 20210522 | ####### | 20210522 | 22/05/2021 | ################# | ||
10 | 20211116 | ####### | 20211116 | 16/11/2021 | ################# | ||
text2no |