USA to UK Dates
 

I have a list of data extracted from elsewhere and the dates are in USA
format
i.e. mm/dd/yyyy

Can excel swap this around to UK format dd/mm/yyyy ?

thanks in advance

--
Vass
................................................
Now: YZF-R1, CBR1100xx-x
Then: A100, MBX80, XL125, CB400, FZR600, CBR600Fv

Hi,
Format the dates to dd/mm/yyyy

Highlight the dates

Format Cells Number tab Date choose the one you need

If it is not in there go to Custom and put dd/mm/yyyy in the space
provided under Type.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381899