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

G

Guest

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.
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is seeing the date as dd/mm/yyyy 4
Converting mm/dd/yyyy to yyyy/mm/dd 6
converting dd/mm/yy to mm/dd/yyyy 3
Forcing a date entry format of dd/mm/yyyy 1
how do I convert English (Canadian) dates to English (US) dates 1
How to Convert 24/03/2010 as text into 03/24/2010 date format 2
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
Month Function on UK dates formats (dd/mm/yyy) 2

Top