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

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

Regards,
Stefi


€žO.C€� ezt Ã*rta:

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

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?

--

O.C Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535475