Date Recognition
Solved
Bestcloever
-
Bestcloever -
Bestcloever -
Hello,
When I am in my Excel data file, the date written is dd/mm/yyyy, but the software only recognizes it when it is entered as yyyy-mm-dd. Is there a way to make a conversion using a formula?
Thank you in advance for your valuable help!
Configuration: Windows / Chrome 59.0.3071.115
When I am in my Excel data file, the date written is dd/mm/yyyy, but the software only recognizes it when it is entered as yyyy-mm-dd. Is there a way to make a conversion using a formula?
Thank you in advance for your valuable help!
Configuration: Windows / Chrome 59.0.3071.115
2 réponses
Hello
if Excel does not recognize the date when you format it as DD/MM/YYYY, it is because it is in text format
try one of these two options
format your column as dd/mm/yyyy
select an empty cell / copy it
select your cell or the field to be processed
right-click / paste special and "add"
or
format an empty column as dd/mm/yyyy
enter this formula if your "dates" are in A1:
=A1*1
or include this calculation in your formulas if you are using A1
and if that doesn't work, provide an Excel list of your problem here:
https://www.cjoint.com/
and come back to paste here the link given by the site
looking forward to hearing from you
best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!
if Excel does not recognize the date when you format it as DD/MM/YYYY, it is because it is in text format
try one of these two options
format your column as dd/mm/yyyy
select an empty cell / copy it
select your cell or the field to be processed
right-click / paste special and "add"
or
format an empty column as dd/mm/yyyy
enter this formula if your "dates" are in A1:
=A1*1
or include this calculation in your formulas if you are using A1
and if that doesn't work, provide an Excel list of your problem here:
https://www.cjoint.com/
and come back to paste here the link given by the site
looking forward to hearing from you
best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!