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

  • Thread starter Thread starter magda
  • Start date Start date
M

magda

Hello,

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

Thanks for replies
 
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
 
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.
 
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
 
Back
Top