0
Anula
Voturi
I am hoping someone can help me with my problem.
I have a xlsx file with the dates formatted in US (m/d/yyyy) style.
I would like to convert them to YYYY/MM/DD format.
I selected the dates in a column.
Clicked the Kutools menu followed by Format and then Apply Date Formatting.
In the Date formatting selection I clicked 2001-03-14 for YYY-MM-DD.
I do not see anything in the Preview side of the dialogue.
If I click Apply, the button is greyed out but I still do not have anything in the Preview side.
See the attachment
Does anyone have an idea why this is not working?
Orice idei?
Chip
I have a xlsx file with the dates formatted in US (m/d/yyyy) style.
I would like to convert them to YYYY/MM/DD format.
I selected the dates in a column.
Clicked the Kutools menu followed by Format and then Apply Date Formatting.
In the Date formatting selection I clicked 2001-03-14 for YYY-MM-DD.
I do not see anything in the Preview side of the dialogue.
If I click Apply, the button is greyed out but I still do not have anything in the Preview side.
See the attachment
Does anyone have an idea why this is not working?
Orice idei?
Chip
0
Anula
Voturi
Hi cheadrick,
I just check the function on my computer, it worked well. So, please tell me the version of the Kutools for Excel you are using. Also, please send me the information about your operating system ( Ce versiune de sistem de operare Windows rulez? ), versiunea Excel și limba pe care o utilizați pe computer.
Mulțumesc în avans.
Amanda
I just check the function on my computer, it worked well. So, please tell me the version of the Kutools for Excel you are using. Also, please send me the information about your operating system ( Ce versiune de sistem de operare Windows rulez? ), versiunea Excel și limba pe care o utilizați pe computer.
Mulțumesc în avans.
Amanda
Bună,
I am using English language for my operating system and all applications.
Kutools for Excel Version 26.0 with Licensed quantity 1
from System Settings:
System type 64-bit operating system, x64-based processor
Edition 10.0.19043 Build 19043
Version 21H1
OS Build 19043.1526
from Excel desktop app:
Microsoft® Excel® pentru Microsoft 365 MSO (Versiunea 2201 Build 16.0.14827.20198) 64 de biți
Chip
I am using English language for my operating system and all applications.
Kutools for Excel Version 26.0 with Licensed quantity 1
from System Settings:
System type 64-bit operating system, x64-based processor
Edition 10.0.19043 Build 19043
Version 21H1
OS Build 19043.1526
from Excel desktop app:
Microsoft® Excel® pentru Microsoft 365 MSO (Versiunea 2201 Build 16.0.14827.20198) 64 de biți
Chip
0
Anula
Voturi
Hi Chip,
Could you please check if the dates in the F column are formatted as text or not?
Mulțumesc în avans.
Amanda
Could you please check if the dates in the F column are formatted as text or not?
Mulțumesc în avans.
Amanda
I changed the column Format to TEXT and tried to Apply Date Formatting.
I still do not get the dates to change to YYYY-MM-DD.
After running this command the Format is changed to DATE.
I have also tried when the column is formatted as GENERAL and get the same results.
See the Attachments.
Chip
I still do not get the dates to change to YYYY-MM-DD.
After running this command the Format is changed to DATE.
I have also tried when the column is formatted as GENERAL and get the same results.
See the Attachments.
Chip
0
Anula
Voturi
Hi Chip,
Is it OK for you to attach the excel file and send that to me? Before you do it, please delete private information.
Mulțumesc în avans.
Amanda
Is it OK for you to attach the excel file and send that to me? Before you do it, please delete private information.
Mulțumesc în avans.
Amanda
0
Anula
Voturi
Hi Chip,
We've just checked the data. The dates in your excel are somehow not standard dates so that Excel could not recognize them and treat them as text. This is why the Date Formatting does not work.
Aici este soluția: Inainte de you apply Date Formatting, please convert them to standard dates first. Please do as follows:
1. Select all the dates.
2. Găsiți Domenii și celule grup sub Kutools tab.
3. clic Conţinut și selectați Convertiți în dată.
After this, you will find Aplicați formatarea datei lucrând corect.
Amanda
We've just checked the data. The dates in your excel are somehow not standard dates so that Excel could not recognize them and treat them as text. This is why the Date Formatting does not work.
Aici este soluția: Inainte de you apply Date Formatting, please convert them to standard dates first. Please do as follows:
1. Select all the dates.
2. Găsiți Domenii și celule grup sub Kutools tab.
3. clic Conţinut și selectați Convertiți în dată.
After this, you will find Aplicați formatarea datei lucrând corect.
Amanda
Buna Amanda,
When I clicked Content then Convert to Date the cells were changed to YYYY-MM-DD as I wanted without having to use Apply Date Formatting. see attachment.
The dates are now in the format I need.
The original file was downloaded from an American site as a CSV file.
I opened the CSV file and saved it in XLSX format before trying to Apply Date Formatting.
Could this have caused my problem?
I would just like to know for the next time I download this file again.
Mulțumesc,
Chip
When I clicked Content then Convert to Date the cells were changed to YYYY-MM-DD as I wanted without having to use Apply Date Formatting. see attachment.
The dates are now in the format I need.
The original file was downloaded from an American site as a CSV file.
I opened the CSV file and saved it in XLSX format before trying to Apply Date Formatting.
Could this have caused my problem?
I would just like to know for the next time I download this file again.
Mulțumesc,
Chip
0
Anula
Voturi
The original file was downloaded from an American site as a CSV file.
I opened the CSV file and saved it in XLSX format before trying to Apply Date Formatting.
Could this have caused my problem?
Hi Chip,
Yes, this might be the reason. We were wondering you might get the file somewhere but not made it yourself since the situation is kinda weird.
So next time when you download similar files online, remember to apply the Convertiți în dată feature to the dates
Amanda
- Pagina:
- 1
Nu există răspunsuri făcute pentru acest post.