convert date mm/dd/yyyy to dd/mm/yyyy

[maryj]

I am in the US. How can I convert dates from the US format to Euorpean but
still have the dates be dates and not text. The custom format dd/mm/yyyy
makes the dates display the correct way but they are still actually in the US
format.

 

[Niek Otten]

<they are still actually in the US format.>

They're not. There is no internal "date format". Dates are stored as the number of days since 1-1-1900 (the date serial number).
They are displayed according to the format string.

Format as General to check that both dates represent the same date serial number.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I am in the US. How can I convert dates from the US format to Euorpean but
| still have the dates be dates and not text. The custom format dd/mm/yyyy
| makes the dates display the correct way but they are still actually in the US
| format.
| --
| maryj

 

[Teethless mama]

Custom Format

dd/mm/yyyy