date conversion from mm/dd/yy to dd/mm/yy

M

magda

Hello,

does anybody know how to convert date from mm/dd/yy (american) t
dd/mm/yy (european).

Thanks for replies
 
P

Peo Sjoblom

Change the date format in the control panel in the regional settings or if
it is for display only
use a custom format dd/mm/yy

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
A

Andy B

Hi

If it is a proper Excel date, it is purely the formatting that displays it
as American. If you select the cell/range and then Format / Cells / Number
tab, selec Custom from the list and in the little box type dd/mm/yy

Hope this helps.
 
H

Harald Staff

Hi

A date is a date is a date. dd/mm and mm/dd are just different ways to
display it, usually as set in the control panel's regional settings.

HTH. Best wishes Harald
 

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

converting dd/mm/yy to mm/dd/yyyy 3
can I change the date format as dd-mm-yy 7
Change date format in Excel footer 2
Date Format 2
change DD/MM/YY to MM/DD/YY 6
How do I convert from a julian date to a standard date mm/dd/yyy 3
how do I convert English (Canadian) dates to English (US) dates 1
How to enter a date in DD-MM-YYYY format 2

Top