Date convertion

[Guest]

I have a colum of dates that are in the US date format mm/dd/yy I want to
change them to the Irish format dd/mm/yy when I do this from the custom
formats it does not work

 

[Guest]

In cell formatting select date and in the language/country drop down list
select English/Ireland!

Regards,
Stefi


„O.C†ezt írta:

 

[Bryan Hessey]

Hi,

Dates are stored in numeric form and displayed as requested by the
Format selected, see

http://www.mvps.org/dmcritchie/excel/datetime.htm

for a better explanation.

If your change of format didn't work then you need to look at the
format of the column, are all dates wrongly displayed, or just those
with day > 12?

Any further clues to your problem?

--