The DATEVALUE Function Does Not Work Well

[soleimani1967]

Hi everybody,

I tried to use some other formulas but the DATEVALUE does not work well.
Please see the attached excel file.
How can I fix this problem?

[alansidman]

The DateValue formula converts text dates to true dates. Your values in Column A are already formatted as Dates. What are you trying to do in column B. Suggest you explain what you want and not what isn't working for you. We need more information.

[etaf]

also some of those dates are formatted as text

[soleimani1967]

I want to change all cells to the same date format . As you can see, some formats are in English (UK) and some formats in English (US). The cells with the English (US) format are convertible to the value, while English (UK) formats are not convertible to the value. I think that the best way is to convert all text to a value. But it does not work.

[sandy666]

maybe

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

formatted as date

[soleimani1967]

Thanks. But I use Excel 2010. There is not this module in Microsoft Excel 2010.
Function of =VALUE(A2) does not work.

[sandy666]

Thanks. But I use Excel 2010. There is not this module in Microsoft Excel 2010.
Function of =VALUE(A2) does not work.

I see XL2013 in your profile
2023-07-01_195407.png

Interesting why it doesn't work

anyway you can try Text2Columns

[soleimani1967]

Thank you so much for your help. I strongly appreciate your solution.

[sandy666]

You are welcome